home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Fritz: All Fritz
/
All Fritz.zip
/
All Fritz
/
FILES
/
BUSINESS
/
DAYOMAT2.LZH
/
DAYOWD.EXE
/
DAYOMRP.DOC
< prev
next >
Wrap
Text File
|
1992-06-01
|
452KB
|
5,587 lines
╔════════════════════════════════════════════════════════════════════════════╗
║ ║
║ ║
║ █▄███████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║
║ █▀███████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║
║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║
║ ║
║ ║
║ ║
║ ███▄ ▄███▒░ ║
║ █████▒░ █████▒░ ███▄███████▒░ ║
║ ██████▒░██████▒░ ███▒░ ███▒░ ███▄███████▒░ ║
║ ███▒██████▒███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║
║ ███▒░████▒░███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║
║ ███▒░ ██▒░ ███▒░ ███████████▒░ ███▒░ ███▒░ ║
║ ███▒░ ██▒░ ███▒░ ███▀████▒░ ███▀███████▒░ ║
║ ███▒░ ▀▀ ███▒░ ███▒░▀███▒░ ███▒░ ║
║ ███▒░ ███▒░ ███▒░ ▀███▒░ ███▒░ ║
║ ███▒░ ▀███▒░ ███▒░ ║
║ ███▒░ ║
║ ║
║ ║
║ MATERIALS REQUIREMENT PLANNING MODULE ║
║ ║
║ ║
║ Copyright (c) 1990-92, TJS LAB, INC, PO Box 585366, Orlando, Florida 32858 ║
║ ║
║ ██████ ▀███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ S H N ║
║ ▀ ██ ▀ ████ ▀▀▀▀▀███████████████████████████▌ O A E ║
║ ██ ██ ▄███▄ ▀████▀▀ ▀████████████ F R T ║
║ ██ ██ ██ ▀▀ ███████████ T D W ║
║ ██ ▄ ██ ▀███▄ Specializing In ▐█████████▌ W W O ║
║ ▀███▀ ██ MicroComputer & Network ██████████ A A R ║
║ ▀███▀ Solutions & █████*████▌ R R K ║
║ Applications ▐███████████ E E S ║
║ ▀██ █ ▀█▄███▄ ┌─┐ ┌─┐ ███████████▌ ║
║ ██ █▀█ ██ ██ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ Custom: ║
║ ██ ▄█ █▄ █████ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ Programs ║
║ ██ ██▄██ ██ ██ ▐▀▌ └───╜ ▐▀▌ ███▄▄███ Reports ║
║ ████ ▄█ █▄ █▀███▀ █████ ▐▀▌ █████ ▀█████▌ Routines ║
║ █████ ▀▀▀█ Forms ║
║ P.O. Box 585366 █ ║
║ Orlando, Florida 32858-5366 (407) 291-3960 ▄▄▄▄▀ ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida
■ SOFTWARE SUPPORT POLICY
1. TJS LAB does not support users of unregistered DAYO products with the
exception of installation questions.
2. Support (included with registration) remains in effect for 3 months
after date of registration or purchase.
3. Support is available through the following methods:
- Phone/Voice Mail: (407) 291-3960/6987
- U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366
- Compuserve Easyplex: 76367,1401
4. Any errors ("bugs or features') in the program will be corrected and
the 'fix' sent promptly (via modem if possible).
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
1......INTRODUCTION
2......SAMPLE DIAGRAM OF A BILL OF MATERIALS
2......ANOTHER EXAMPLE OF A BILL OF MATERIALS FOR AN ENDITEM
3......EVEN ANOTHER EXAMPLE OF A BILL OF MATERIALS FOR AN ENDITEM
3......COPYRIGHT/LICENSE
3......DISCLAIMER
4......REQUIREMENTS ***
4......SETUP
5......MAIN MENU
5......PASSWORD/NAME
6......SHOP ORDERS
7......CREATE A NEW SHOP ORDER
8......EXAMPLE OF SHOP ORDER NOTES INPUT
9......SHOP ORDER BROWSE & MAINTENANCE
10......FULL SCREEN EDIT - F2
10......EDIT SHOP ORDER NOTES
11......ADD RECORD TO SHOP ORDER - CTRL N
11......DELETE SHOP ORDER RECORD - CTRL U
11......RESET SHOP ORDER TOTAL COST - ALT F1
11......FIND SHOP ORDER RECORD
12......ALLOCATE SHOP ORDER
13......TRANSFER TO W.I.P.
15......ASSEMBLE SHOP ORDER
17......UPDATE INVENTORY WITH FINISHED ENDITEMS
19......PRINT/REPRINT SHOP ORDER
20......EXAMPLE OF A SHOP ORDER
21......PRINT/REPRINT A TRAVELER
22......EXAMPLE OF A USER DEFINED TRAVELER
23......MAKE SHOP ORDERS FROM BACK ORDERS
25......FILE MAINTENANCE FOR SHOP ORDERS
26......BILL OF MATERIALS (BOM) BROWSE & MAINTENANCE
27......FULL SCREEN EDIT - F2
28......CREATE A NEW BILL OF MATERIALS (BOM) - F3
29......ADD COMPONENT ITEMS TO NEW BILL OF MATERIALS (BOM)
30......ADD ITEM FROM INVENTORY FOR CURRENT BOM - CTRL N
31......DELETE BOM RECORD - CTRL U
31......RESORT A BOM - CTRL F10
31......RESET ITEM FIELD
32......BOM TRANSFERS TO/FROM INVENTORY ONHAND & BOM WIP_QTY - ALT F5
33......ASSEMBLE CURRENT ENDITEM - ALT F6
34......UNASSEMBLE CURRENT ENDITEM - ALT F7
35......PRINT TRAVELER - ALT P
35......FIND BOM RECORD F5
35......CURRENT INDEX - F6
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
36......REPORTS
36......REPORTS/ROUTINES LISTING
37......ENDITEMS LIST
37......ENDITEMS LIST EXAMPLE
38......ENDITEMS EXPANDED REPORT #1
38......ENDITEMS EXPANDED REPORT #2
39......ABBREVIATED BILL OF MATERIALS REPORT
40......ABBREVIATED BILL OF MATERIALS REPORT EXAMPLE
41......BOM FLOW CHART #1
42......BOM FLOW CHART #2
43......BOM FLOW CHART #3
44......ALL - BOM FLOW CHART #1
46......ALL - BOM FLOW CHART #2A
47......ALL - BOM FLOW CHART #3A
48......BOM SHORTAGE REPORT
49......BOM SHORTAGE REPORT EXAMPLE
50......SHOP ORDERS LIST
51......SHOP ORDERS LIST EXAMPLE
52......SHOP ORDERS EXPANDED #1
53......SHOP ORDERS EXPANDED #2
54......SHOP ORDERS HISTORY #1
55......SHOP ORDERS HISTORY #2
56......MANUFACTURING HISTORY REPORT
57......MANUFACTURING HISTORY FOR A SINGLE ITEM REPORT
58......COMPONENT/WHEREIS ITEM REPORT
58.1....ALLOCATION REPORT
59......VIEW REPORTS ON SCREEN
60......REPORT VIEWING SCREEN
61......CONFIGURATION STATUS REPORT
61......EXAMPLE OF THE CONFIGURATIONS SETTINGS REPORT
62......PRINTER DRIVER (SETUP)
62......PRINTER DRIVER OPTIONS
63......CHANGE DEFAULT PRINTER
64......FULL SCREEN EDIT - F2
64......PRINTER DRIVER DATABASE FIELD DEFINITIONS
65......CONFIGURATION
65......CONFIGURATION OPTIONS LISTING
66......COMPANY NAME
66......COMPANY ADDRESS
66......COMPANY TELEPHONE
66......MRP CLASS CODES
67......ALLOW BROWSE EDITING
67......INVENTORY LOCATION/DIRECTORY
67......BACK ORDERS LOCATION/DIRECTORY
67......CUSTOMERS (AR) LOCATION/DIRECTORY
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
68......POINT OF SALE (POS) LOCATION/DIRECTORY
68......GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY
68......CURRENT DIRECTORY DATABASE LOCATION
68......REPORT PRINTER TYPE
68......REPORT PRINTER PORT
69......VISUAL INDEXING
69......AUTOMATIC DAILY INDEXING
69......AUTOMATICALLY PRINT SHOP ORDERS WHEN CREATED
69......SHOP ORDER PRINTER TYPE
70......SHOP ORDER PRINTER TYPE
70......PRINT DUEDATE ON SHOP ORDER
70......NUMBER OF SHOP ORDER COPIES TO PRINT
70......SHOP ORDER PRINTER PORT
70......LAST SHOP ORDER NUMBER
71......TRAVELER PRINTER TYPE
71......TRAVELER PRINTER PORT
71......LAST TRAVELER NUMBER
71......SKIP PAGE BETWEEN ENDITEMS ON THE TRAVELERS
72......TRAVELER SETUP & DEFINITION
72......TRAVELER STYLE/TYPE
73......TRAVELER FIELDS
74......DEFINED FIELDS
74......AUTOMATIC GL POSTING
75......EDIT CLASS CODE RECORD
75......ADD NEW CLASS CODE RECORD
76......FIND CLASS CODE
76......COLOR MONITOR
76......COLOR INTENSITY
77......MISCELLANEOUS ROUTINES
77......MISC ROUTINES MENU:
78......APPEND FROM
80......BROWSE DATABASES
82......COPY (.DBF) TO
84......CREATE DATABASE
86......DELETE RECORDS
87......ERASE FILE
87......EXIT TO DOS
88......INDEX A DATABASE
89......LIST FIELDS
92......MODIFY DATABASE
93......PACK DATABASE
94......RECALL RECORDS
94......RETURN TO MENU
94......RUN (DOS COMMAND)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida
Table of Contents
Page Subject
──── ──────────────────────────────────────────────────────────
95......SIMPLE EDITOR
96......SORT DATABASE
97......TYPE (PRINT) FILE
98......ZAP DATABASE
100......HELP SCREENS
101......EXPANDED HELP
102......USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
103......VIEW DOCUMENTATION ONSCREEN
104......DATABASE STRUCTURES
104......BOM.DBF STRUCTURE
105......SO.DBF STRUCTURE
105......SOHIST.DBF STRUCTURE
106......SO_NOTES.DBF STRUCTURE
106......DATA DICTIONARY
109......DAYO MRP MAINTENANCE & QUIRKS
110......TJS 'Computer' LAB
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 1
■ INTRODUCTION
DAYO Materials Requirement Planning (MRP) is a module designed for use
by manufacturers or anyone that 'builds' items from other items in their
inventory. DAYO MRP provides you with a method of building items (ENDITEMS)
from other items. This module is totally integrated with DAYO Inventory and
other DAYO modules.
The MRP process starts with the defining of the Bill of Materials (BOM)
for an ENDITEM. After defining the BOM, you can 'build' the new item from
items in the inventory database INV.DBF (if the items are available).
The MRP process takes quantity from the inventory database and places it
in the Work in Process (WIP) quantity fields in the database BOM.DBF. When
enough of every sub component to an ENDITEM is obtained, the process will
produce the ENDITEM which can in turn be placed into the inventory
database.
Some of the DAYO MRP highlights are:
Multiuser (ie: Novell)
Shop Orders
Multi-level ENDITEMS & Component Items
Travelers (2 Types/Styles)
Automatic Inventory Posting
Many Reports, ie: ENDITEM lists, Shop Orders and Bill of Materials
Databases are dBase (tm) Compatible
Miscellaneous Database Routines
Passwords (with DAYO Passwords)
Other DAYO Products:
DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving
DAYO POS Point of Sales Billing & Invoicing
DAYO Quotes Sales Quoting System
DAYO Price Books Special pricing for your customers as well as a wide
range of product catalogs/reports
DAYO AR Accounts Receivable
DAYO AP Accounts Payable
DAYO EOP End of Period Post & Pack, Physical Inventory
DAYO BO Back Orders
DAYO GL General Ledger
DAYO Smart Reports A variety of reports pertaining to the above modules
DAYO Passwords Password protect your DAYO system
DAYOX Network/LAN Index Maintenance Utility
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 2
■ SAMPLE DIAGRAM OF A BILL OF MATERIALS
To help illustrate a Bill of Materials for an ENDITEM, the following
diagram is given for an imaginary ENDITEM (78000):
COMPONENT ITEMS
┌───────────────────┐
COMPONENT ITEMS │Item 21461 (10 per)│
& SUB ENDITEMS │Item 93571 (5 per) │
┌───────────────────┐ ┌──┤Item 97561 (4 per) │
│Item 12464 (1 per)─┼<─┘ │Item 97567 (4 per) │
│Item 13466 (10 per)│ └───────────────────┘
│Item 75647 (2 per) │ ┌───────────────────┐
│Item 15675 (1 per)─┤<────┤Item 44314 (1 per) │
│Item 70930 (1 per) │ │Item 37241 (30 per)│
│Item 8393A (1 per) │ └───────────────────┘
ENDITEM │Item 8393B (1 per) │ ┌───────────────────┐
┌──────────────┐ │Item 28868 (4 per) │ │Item 45771 (3 per) │
│ENDITEM 78000 ├<───┤Item 28686 (5 per) │ │Item 14745 (3 per) │
└──────────────┘ │Item 12688 (5 per)─┼<────┤Item 67865 (3 per) │
│Item 83930 (1 per) │ └───────────────────┘
│Item 34230 (1 per) │
│Item 86770 (1 per) │ ┌───────────────────┐
│Item 99777 (1 per) │ │Item 56751 (1 per) │
│Item 37599 (1 per)─┼<────┤Item 10033 (10 per)│
│Item 92039 (2 per) │ └───────────────────┘
│Item 97647 (1 per)─┼<─┐ ┌───────────────────┐
│Item 94579 (1 per) │ └──┤Item 10000 (1 per) │
└───────────────────┘ │Item 45651 (1 per) │
│Item 23715 (5 per) │
│Item 76431 (5 per) │
└───────────────────┘
*** Note that the Bill of Materials for ENDITEM 78000 requires 138
component items! *** Also note that there is no limit to the number of BOM
sub levels...
■ ANOTHER EXAMPLE OF A BILL OF MATERIALS FOR AN ENDITEM
Not all BOMs need to be complex. The following diagram depicts the BOM
for ENDITEM: PICTURE-1020
┌───────────────┐
│PHOTO (1 per) │
┌──────────────────────┐ │TACKS (2 per) │
│ENDITEM: PICTURE-1020 ├<─────┤BOX-6X7 (1 per)│
└──────────────────────┘ │PADDING (1 per)│
└───────────────┘
*** Note that the Bill of Materials for ENDITEM PICTURE-1020 requires
5 component items!
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 3
■ EVEN ANOTHER EXAMPLE OF A BILL OF MATERIALS FOR AN ENDITEM
ENDITEM LEVEL1 LEVEL2
---------- ---------- ----------
MOTOR123
MOTOR123 * DOOR
MOTOR123 DOOR DOORHANDLE
MOTOR123 DOOR DOORLOCK
MOTOR123 DOOR DOORGLASS
MOTOR123 * WHEELS4
MOTOR123 WHEELS4 TIRES4
MOTOR123 WHEELS4 RIMS4
MOTOR123 WHEELS4 BOLTS20
MOTOR123 * RADIO
MOTOR123 RADIO SPEAKERS
MOTOR123 RADIO WOOFERS
MOTOR123 RADIO WIRING
* Asterisked items are Sub-ENDITEMS. Also note that 9 component items
comprise the ENDITEM (MOTOR123).
■ COPYRIGHT/LICENSE
This manual and software is copyrighted with all rights reserved by
TJS LAB. No copying of this manual or software is authorized without
the prior written consent of TJS LAB. An exception to this rule is the
making of backup copies of registered software disks. No RESALE of any part
of the source codes is authorized without the prior written consent of
TJS LAB. TJS LAB retains all rights to DAYO MRP software, documentation,
and source codes.
■ DISCLAIMER
No warrant is made that this software will work in all environments,
or with all resident programs and hardware configurations. TJS LAB has
tested this software in many environments and found it to perform as
expected, however, this software is licensed "AS IS".
TJS LAB will not be liable for any damage done to your data, hardware,
and/or software systems as a result of using DAYO MRP.
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 4
■ REQUIREMENTS ***
IBM or Compatible CPU
640K memory
* DOS 3.3 or above
Hard Disk
■ SETUP
To setup DAYO MRP, use the SETUP program found on the DAYO Menu or
Update disk, or copy the contents of the DAYO MRP floppy disk into a
directory on your hard disk (ie: \DAYOMRP). DAYO MRP will create all the
database, index, and configuration files it requires for operation the first
time it is 'run'. If you are using other DAYO modules, be sure to enter the
location of these databases into the DAYO MRP configuration. Type and enter
'DAYOW' at the DOS prompt to run the program (ie: C:\DAYOW ).
Be sure to insure that your CONFIG.SYS file (found on your boot up disk),
has an adequate 'FILES' statement in it, ie: 'FILES=99'.
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 5
■ MAIN MENU
From the main menu, you can access all the major menu options, or return
to DOS...
DAYO MRP Version 3.0 TJS LAB ┌──[February 1991]───┐
█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ │S M T W T F S │
█ 1 SHOP ORDERS █ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
█──────────────────────█ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5│
█ 2 BILL OF MATERIALS █ █░ █░ █░█░ ▀█░██░ █░ █░ │ 6 7 8 9 10 11 12│
█──────────────────────█ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │13 14 15 16 17 18 19│
█ 3 REPORTS █ █░ █░ █░ █░ █░ █░ █░ │20 21 22 23 24 25 26│
█──────────────────────█ █▀██▀ █░ █░ █░ ▀███▀ │27 28 29 30 31 │
█ 4 CONFIGURATION █ │ │
█──────────────────────█ Copyright (c) 1990-1991 └────────────────────┘
█ 5 MISC ROUTINES █
█──────────────────────█ ███▄ ▄███░
█ 6 EXIT █ █████░ █████░ ███▄███████░
███▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀███ ██████░ ██████░ ███░ ███░ ███▄███████░
██ Manufacturing ██ ███░██████░███░ ███░ ███░ ███░ ███░
█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█ ███░ ████░ ███░ ███░ ███░ ███░ ███░
███░ ██░ ███░ ███████████░ ███░ ███░
███░ ██░ ███░ ███▀████░ ███▀███████░
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ ███░ ▀▀ ███░ ███░ ▀███░ ███░
█Database # Records Size█ ███░ ███░ ███░ ▀███░ ███░
█BOM 8802 1731632█ Materials ███░ ▀███░ ███░
█INV 5326 1189272█ Requirement ███░
█INVADJ 44562 2317587█ Planning
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Build Enditems, Shop Orders, Planning Tools
■ PASSWORD/NAME
From the main menu you can enter any of the routines/options, but not
until you enter your name (or password if using DAYO Passwords):
┌────────────────────────────────────────────────────────────────────────────┐
│┌──────────────────────────────────────────────────────────────────────────┐│
││ Enter Your Name: George Moonilal ││
│└──────────────────────────────────────────────────────────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 6
■ SHOP ORDERS
Shop orders contain a group (1 or more) of ENDITEMS that are to be
assembled or built. In DAYO MRP, shop orders can be 'tied' to a customer,
invoice, back order invoice, or a user inputted comment.
The use of shop orders is not required to assemble ENDITEMS, the BOM
routine has the capability to do the job...
Shop orders are used to schedule the production of ENDITEMs. They also
provide a means of prioritizing the assemble process.
If using shop orders, the assembly stage is broken down into 5 steps:
1. Create
2. Allocate (add to the required quantity in database BOM.DBF)
3. Transfer ('move' quantities from the inventory to the BOM database,
into the field 'WIP_QTY'. This step creates inventory
adjustment records for items taken from the inventory
database)
4. Assemble (Create the ENDITEM if enough required WIP quantity is
present)
5. Update the Inventory (Move the finished/assembled ENDITEMs from the
BOM database to the inventory database.
Inventory adjustment records are created at this
point for the quantities moved)
DAYO MRP Version 3.0 TJS LAB
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ ▄███░ ██░ ██░ ▄███▄ █▄███░
█ SHOP ORDERS █ ██░ ██░ ██░ ██░██░ ██░██░
█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ ▀██▄ ██████░ ██░██░ ██▀██░
█ CREATE SHOP ORDER █ ██░ ██░ ██░ ██░██░ ██░
█ BROWSE SHOP ORDERS █ ███▀ ██░ ██░ ▀███▀ ██░
█ ALLOCATE SHOP ORDER █
█ TRANSFERS: W.I.P. █ ▄███▄ █▄███░ █▄███░ ████░ █▄███░ ▄███░
█ ASSEMBLE SHOP ORDER █ ██░██░ ██░██░ ██░██░ ██░ ██░██░ ██░
█ UPDATE INVENTORY █ ██░██░ ██▄██░ ██░██░ ███░ ██▄██░ ▀██▄
█ RE/PRINT SHOP ORDER █ ██░██░ ██▀█▄ ██░██░ ██░ ██▀█▄ ██░
█ RE/PRINT TRAVELER █ ▀███▀ ██░██░ █▀███░ ████░ ██░██░ ███▀
█ BO SHOP ORDERS █
█ SO FILE MAINTENANCE █ ███▄ ▄███░
█ EXIT █ █████░ █████░ ███▄███████░
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ ██████░ ██████░ ███░ ███░ ███▄███████░
███░██████░███░ ███░ ███░ ███░ ███░
███░ ████░ ███░ ███░ ███░ ███░ ███░
███░ ██░ ███░ ███████████░ ███░ ███░
█ █░ ███░ █▄██░ ███░ ██░ ███░ ███▀████░ ███▀███████░
█ ▄ █░ █░ █░ █░ ███░ ▀▀ ███░ ███░ ▀███░ ███░
█▄ █░▄█░ █░ █░ █░ ███░ ███░ ███░ ▀███░ ███░
█▄█▄█░ █░ █▀▀▀ ███░ ▀███░ ███░
█░█░■ ███░■ █░■ ███░
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 7
■ CREATE A NEW SHOP ORDER
This menu option is used to create new shop orders. A browse selection
of all unique ENDITEMS is displayed onto the screen. Find the ENDITEM(s) you
want, then press enter to select.
╔═════════════════════════[ CREATE A NEW SHOP ORDER ]════════════════════════╗
║ ENDITEM DESC COST ║
║ Select the ╔═══════════════╤════════════════════════════════╤════════════║
║ ENDITEMS ->║ A2345 │ BIG CAR │ 3432.060 ║
║ for this ║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 16.528 ║
║ Shop Order. ║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 17.560 ║
║ ║ BP0003 │ GATOR COFFEE MUG WITH LID │ 18.590 ║
║ █▄ █░ ║ C234234 │ PALADINO NYLON 3-PKT BELLY BAG │ 4.132 ║
║ ██▄ █░ ║ DD23F │ DOOR │ 5.160 ║
║ █░█▄█░ ║ E2323 │ HANDLE, DOOR │ 6.190 ║
║ █░ ▀█░ ║ H23Q │ ADULT BELLY BAGS │ 9.290 ║
║ ║ I2435 │ ADULT-4 PKT BELLY BAGS │ 10.330 ║
║ ████░ ║ J4432 │ ADULT-2 PKT BELLY BAG │ 11.360 ║
║ █▄▄ ║ J64634 │ WIDE MOUTH HIPPO │ 0.000 ║
║ █▀▀ ║ │ │ ║
║ ████░ ║ │ │ ║
║ ║ │ │ ║
║ █░ █░ ║ │ │ ║
║ █░ █░ ║ │ │ ║
║ █▄█▄█░ ║ │ │ ║
║ █░█░ ║ │ │ ║
╚══════════════╩═════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (List Selections)
A window will appear onto the screen with prompts for key information
about the shop order record. Note, a positive quantity is required. The
customer and invoice number is not required. Use the COMMENT field for
anything you want.
╔═══════════════════════════════════════════════════════════════║
║ Enditem: A2345 ║
║ Desc: BIG CAR ║
║ ║
║ Comment: Comment Here! ║
║ * Quantity: 1.000 ║
║ ║
║ Customer: 1000 ║
║ Invoice: 23224 ║
║ Due Date: 01/19/91 ║
║ ║
║ Cost: 2432.060 ║
║ ║
║ Hours: 3.220 ║
║ Labor: 3.761 ║
║ Labor1: 4.137 ║
║ Labor2: 5.642 ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 8
Press F2 while adding ENDITEMs to the new shop order to display all
records so far added to the shop order.
╔═══════════════════[ SHOP ORDER (40) - LIST OF ENDITEMS ]═══════════════════╗
║ ENDITEM DESCRIPTION COMMENT ║
║ A2345 BIG CAR George Moonilal & Sons ║
║ J42343 NEON ADULT-2 PKT BELLY BAG Shiner's Cars ║
║ C2434 PALADINO NYLON 3-PKT BELLY BAG Green Dist. Inc. ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Press any key to continue...
After adding the ENDITEMS, you have the option of adding any comments
to the shop order. Note, only the first 21 lines of the notes will print
onto the shop order.
╔════════════════════════════════════════════════════════════════════╗
║ Do you wish to add any notes to this Shop Order? (Y/N) ■ ║
╚════════════════════════════════════════════════════════════════════╝
■ EXAMPLE OF SHOP ORDER NOTES INPUT
─────────────────────────────[ SHOP ORDER NOTES ]─────────────────────────────
Put ANY information, comments
or notes
in this routine!
──────────────────────────────────────────────────────────────────────────────
Esc (Exit) Ctrl W (SAVE & Exit) F1 (Help) 5/16
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 9
■ SHOP ORDER BROWSE & MAINTENANCE
This is the maintenance routine for shop orders already created. Use
this routine to view, edit fields, edit notes, add ENDITEMS to existing
shop orders, delete shop order records, and to reset total cost for a shop
order (recorded in the shop order notes database: SO_NOTES.DBF).
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄[ SHOP ORDER BROWSE & MAINTENANCE ]▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
█ Shop Order: 10002 Invoice: 5054 Customer: 40003 ENDITEM: BP0003 █
█ Comment: Shelf Stockage #89 Desc: GATOR STEM GLASS █
█ QTY: 9.000 Assembled: 0.000 Cost: 18.594 █
█ Date Added: 01/05/91 Last Date Accessed: 01/06/91 Due 01/05/91 █
█ Hours: 3.766 Labor: 5.268 Labor1: 5.795 Labor2: 6.848█
█ Status: Open Allocated?: No Printed?: No Priority: 0.00 █
█ Onhand: 501.000 OnOrder: 0.000 Back Ordered: 0.000 █
█▄▄▄▄▌Total Cost: 2.069▐▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█
█ SO COMMENT ENDITEM █
█───────────────────╥────────────────────────────────╥───────────────────────█
█ 10001 ║ For Green & Co. ║ A10001 █
█ 10001 ║ For Green & Co. ║ A10001 █
█ 10002 ║ Shelf Stockage #23 ║ BP0003 █
█ 10002 ║ Shelf Stockage #89 ║ BP0003 █
█ 10003 ║ Martin ║ BP3 █
█ 10003 ║ Martin ║ BP3 █
█ 10003 ║ Martin ║ BP3 █
█ 10004 ║ Glassware, Inc ║ D90001 █
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Esc (Exit) F1 (Help) F2 (Edit) Ctrl F1 (Shop Order Notes)
Ctrl N (Add) Ctrl U (Delete) Alt F1 (Reset Total)
F5 (SO) F6 (Comment) F7 (Enditem) F8 (Desc) F9 (Customer) F10 (Invoice)
<INSERT ON> 6/100
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 10
■ FULL SCREEN EDIT - F2
Press F2 to view and subsequently edit all the fields onto the screen
at once.
┌────────────────────[ FULL SCREEN EDIT - ENDITEMS.DBF ]─────────────────────┐
│ SO: 10002 │
│ COMMENT: For Order #838 │
│ ENDITEM: BP0003 │
│ DESC: GATOR GLASS #23 │
│ QTY: 9.000 │
│ COST: 18.594 │
│ ASSEMBLED: 0.000 │
│ DATE: 01/05/91 │
│ DUEDATE: 01/05/91 │
│ LASTDATE: 01/06/91 │
│ HOURS: 3.766 │
│ LABOR: 5.268 │
│ LABOR1: 5.795 │
│ LABOR2: 6.848 │
│ PRIORITY: 0 │
│ OPEN: T │
│ ALLOCATED: F │
│ PRINTED: F │
│ CUSTOMER: 103 │
│ INVOICE: 24244 │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ EDIT SHOP ORDER NOTES
Press Ctrl F1 to edit the shop order notes.
╔════════════════════════════════════════════════════════════════════╗
║ Do you wish to add any notes to this Shop Order? (Y/N) ■ ║
╚════════════════════════════════════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 11
■ ADD RECORD TO SHOP ORDER - CTRL N
Press Ctrl N to add an ENDITEM to an existing shop order.
╔══════════════════════[ ADD RECORD/MODIFY A SHOP ORDER ]════════════════════╗
║ ENDITEM DESC COST ║
║ Select ╔═══════════════╤════════════════════════════════╤════════════║
║ ENDITEMS ->║ A1234 │ BIG CAR #34 │ 1243.060 ║
║ to be added ║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 16.520 ║
║ to this ║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 17.560 ║
║ Shop Order. ║ BP0003 │ GATOR COFFEE MUG WITH LID │ 18.590 ║
║ ▄█▄ ║ C34534 │ PALADINO NYLON 3-PKT BELLY BAG │ 4.130 ║
║ █░█░ ║ D4 │ DOOR │ 5.160 ║
║ ██▀██ ║ E4F │ HANDLE, DOOR │ 6.198 ║
║ █░ █░ ║ HDF345 │ ADULT BELLY BAGS │ 9.290 ║
║ ║ I634 │ NEON ADULT-4 PKT BELLY BAGS │ 10.330 ║
║ █▄███░ ║ J234 │ NEON ADULT-2 PKT BELLY BAG │ 11.360 ║
║ █░ █░ ║ JAR-2 │ JAR #2 │ 0.000 ║
║ █░ █░ ║ R2D2 │ ROBOT #4,404,499,383,383 │ 1.500 ║
║ █▀███░ ║ │ │ ║
║ ║ │ │ ║
║ █▄███░ ║ │ │ ║
║ █░ █░ ║ │ │ ║
║ █░ █░ ║ │ │ ║
║ █▀███░ ║ │ │ ║
╚══════════════╩═════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (List Selections)
■ DELETE SHOP ORDER RECORD - CTRL U
Press Ctrl U to mark a shop order record for deletion. Note, this only
marks the record, use the SO FILE MAINTENANCE routine to 'pack' out the
deleted records.
■ RESET SHOP ORDER TOTAL COST - ALT F1
Press Alt F1 to recompute the total cost for a shop order. The result
is found in the COST field, in the database SO_NOTES.DBF.
■ FIND SHOP ORDER RECORD
Press: F5 to find a shop order based on the SO number
F6 for comment search
F7 for ENDITEM search
F8 for Description search
F9 for Customer search
F10 for Invoice search
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 12
■ ALLOCATE SHOP ORDER
Use this option to update the required quantity field (REQ_QTY) in the
BOM database (BOM.DBF). Note, the required quantity field determines the
maximum total amount of items transferred from the inventory to the WIP
quantity field (WIP_QTY).
╔══════════════════════════[ ALLOCATE SHOP ORDER ]═══════════════════════════╗
║ Shop Order: 10923 Comment: GEN MORGAN Date: 01/05/91║
║ End Item: MISSILE Desc: MISSILE, LONG RANGE Due: 01/05/91║
║ Qty: 1.000 Assembled: 4.000 Cost: 12422.000 Last Date: 01/06/91║
║ Customer: 1212 Invoice: 39901 Hours: 123.418 Labor: 0.000║
║ Priority: 99 Open: Yes Allocated: Yes Printed: Yes ║
║ SO COMMENT ENDITEM ║
║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║
║ Shop ->║ 1212 │ GEN MORGAN │ MISSILE ║
║ Order ║ 1212 │ GEN MORGAN │ TUBEXXAR657 ║
║ Record To ║ 1213 │ Harper Florist │ PAR3-1 ║
║ Allocate ║ 1213 │ │ A244 ║
║ ║ 1213 │ │ C4 ║
║ A ║ 1213 │ (Green Only) │ A234 ║
║ L ║ 1214 │ Geo & Morgan, Inc │ BP0003 ║
║ L ║ 1214 │ Stacy Smithy │ D243 ║
║ O ║ 1215 │ George Moonilal │ A234 ║
║ C ║ 1217 │ Ron Davidson & Co. │ BP0003 ║
║ A ║ 1217 │ Brenda's Teeth │ BTEETH3 ║
║ T ║ 1217 │ Gums │ GUMS123 ║
║ E ║ 1217 │ Bridge │ BRIDGE ║
╚═════════════╩══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F5 - F10 (Find)
You have the option of allocating all records in a shop order, or a
specific record (ENDITEM).
╔═══════════════════════════════════════════════════════════════║
║ Select Option -> Allocate Only Current Shop Order Record ║
║ Allocate Entire Shop Order ║
║ De-Allocate Only Current Shop Order Record ║
║ De-Allocate Entire Shop Order ║
║ Exit/Abort ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 13
The progress of the process is displayed onto the screen:
╔═══════════════════════════════════════════════════════════════║
║(Level) Item Per-Qty Req-Qty Total Cost ║
║MISSILE 0.000 1.000 122167.000 ║
║TRUCK 1.000 12.000 12235.000 ║
║TUBE 4.000 48.000 1230.000 ║
║ LINER 4.000 48.000 2154.900 ║
║ GREASER 8.000 96.000 3233.000 ║
║BREACH 4.000 48.000 2121.200 ║
║CONTROLER 1.000 12.000 12300.000 ║
║ INTERFACE 4.000 48.000 4560.900 ║
║ SEAT 2.000 24.000 25.000 ║
║ AC 1.000 12.000 3005.000 ║
║ STEREO 1.000 12.000 2004.090 ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
■ TRANSFER TO W.I.P.
This is the routine that moves quantity from the inventory database
(INV.DBF) into the BOM database (BOM.DBF), and into the WIP_QTY field.
The amount TRANSFERRED will not exceed the REQ_QTY, but is totally dependant
on the quantity in the inventory ONHAND field.
Inventory adjustment records will be created during this process.
╔═══════════════════════════[ TRANSFER TO W.I.P. ]═══════════════════════════╗
║ Shop Order: 10203 Comment: LaRossa Nose Company Date: 01/05/91║
║ End Item: NOSEITAL05 Desc: Italian Nose, 5 inch Due: 01/05/91║
║ Qty: 11.000 Assembled: 0.000 Cost: 100.000 Last Date: 01/06/91║
║ Customer: 0 Invoice: 0 Hours: 4.603 Labor: 5.605║
║ Priority: 0 Open: Yes Allocated: No Printed: No ║
║ SO COMMENT ENDITEM ║
║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║
║ Shop ->║ 10023 │ Harper's │ BP0003 ║
║ Order ║ 10023 │ │ BP0001 ║
║ Record To ║ 10024 │ Terry J. Smith, Inc │ A243 ║
║ Transfer ║ 10203 │ LaRossa Nose Company │ NOSEITAL05 ║
║ To W.I.P. ║ 10203 │ LaRossa Rose Company │ NOSEITAL10 ║
║ T ║ 11126 │ AAA & Daughters │ C243 ║
║ R ║ 11126 │ │ BP0003 ║
║ A ║ 11126 │ │ APSBH-2 ║
║ N ║ 11126 │ │ C234 ║
║ S ║ 11127 │ Order #231 │ APSBH-2 ║
║ F ║ 11127 │ │ BP0001 ║
║ E ║ 11127 │ │ BP0001 ║
║ R ║ 11127 │ │ BP0003 ║
╚═════════════╩══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F5 - F10 (Find)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 14
You can transfer for a specific shop order record (ENDITEM), or the
entire shop order.
╔═══════════════════════════════════════════════════════════════║
║ This option will attempt to move enough inventory into W.I.P. ║
║ in order make it possible to later assemble the number of ║
║ ENDITEMS that are as yet unassembled. The quantity of ║
║ inventory items transferred will not exceed the required ║
║ quantity as defined in the BOM 'BOM.DBF'. ║
║ ║
║ Select Option -> Transfer To W.I.P. For Current Record ║
║ Transfer To W.I.P. For Entire Shop Order ║
║ Exit/Abort ║
║ ║
║ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
A report can be printed that simply lists the quantities moved.
╔═══════════════════════════════════════════════════════════════║
║ This option will attempt to move enough inventory into W.I.P. ║
║ in order make it possible to later assemble the number of ║
║ ENDITEMS that are as yet unassembled. The quantity of ║
║ inventory items transferred will not exceed the required ║
║ quantity as defined in the BOM 'BOM.DBF'. ║
║ ║
║ Select Option -> Transfer To W.I.P. For Entire Shop Order ║
║ ║
║ Do you want a Printed Report? (Y/N) ■ ║
║ ║
║ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 15
The progress of the operation is displayed onto the screen:
╔═══════════════════════════════════════════════════════════════║
║(Level) Item Per-Qty Req-Qty Transferred ║
║D234 7.000 2.000 1.000 ║
║H243 3.000 2.000 2.000 ║
║YK90086 3.000 19.000 2.000 ║
║A234 0.000 0.000 2.000 ║
║ APSBH-1 10.000 10.000 0.000 ║
║ APSBH-2 2.000 2.000 0.000 ║
║B234 3.000 2.000 7.000 ║
║C4233 4.000 24.000 13.000 ║
║ YK90086 5.000 24.000 14.000 ║
║ YKEL1 3.000 24.000 1.000 ║
║ YKEL2 7.000 27.000 27.000 ║
║ G2434233-3 8.000 3.000 3.000 ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
■ ASSEMBLE SHOP ORDER
This routine will assemble ENDITEMS if possible based on the quantities
found in the WIP_QTY field.
╔══════════════════════════[ ASSEMBLE SHOP ORDER ]═══════════════════════════╗
║ Shop Order: 1005 Comment: Battle King Parlor Date: 01/05/91║
║ End Item: BIGGUNBAR Desc: BIG GUN BAR Due: 01/05/91║
║ Qty: 6.000 Assembled: 4.000 Cost: 112.069 Last Date: 01/06/91║
║ Customer: 0 Invoice: 12330 Hours: 2.510 Labor: 4.762║
║ Priority: 0 Open: Yes Allocated: Yes Printed: Yes ║
║ SO COMMENT ENDITEM ║
║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║
║ Shop ->║ 1005 │ Battle King Parlor │ BIGGUNBAR ║
║ Order ║ 1005 │ │ TAP ║
║ Record To ║ 1022 │ Perkins Boats │ CATAMAR2 ║
║ Be ║ 1022 │ Green │ SAIL32-12 ║
║ Assembled ║ 1022 │ Red │ SAIL32-24 ║
║ A ║ 1023 │ Harley Limpwrist & Friends │ WHIP#1 ║
║ S ║ 1023 │ │ WHIP#2 ║
║ S ║ 1023 │ │ WHIP#3 ║
║ E ║ 1023 │ │ LEATHERRAW ║
║ M ║ 1023 │ #4 │ LEATHERCURE ║
║ B ║ 1023 │ #4 │ BIKER-23 ║
║ L ║ 1023 │ │ SCOOTER ║
║ E ║ 1023 │ │ MOPED-3 ║
╚═════════════╩══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F5 - F10 (Find)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 16
You have the option of assembling the entire shop order, or a specific
shop order record (ENDITEM).
╔═══════════════════════════════════════════════════════════════║
║ This option will assemble then ENDITEM(s) for the Shop ║
║ Order up to the amount not yet assembled. Shortages of the ║
║ components will result in fewer Finished/Assembled ENDITEMS. ║
║ An option exists to print a shortage report for this process. ║
║ ║
║ Select Option -> Assemble Only Current Record ║
║ Assemble Entire Shop Order ║
║ Exit/Abort ║
║ ║
║ ║
║ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
A simple report listing the process can be printed.
╔═══════════════════════════════════════════════════════════════║
║ This option will assemble then ENDITEM(s) for the Shop ║
║ Order up to the amount not yet assembled. Shortages of the ║
║ components will result in fewer Finished/Assembled ENDITEMS. ║
║ An option exists to print a shortage report for this process. ║
║ ║
║ Select Option -> Assemble Entire Shop Order ║
║ ║
║ Do you wish to pause between ENDITEMs, to adjust the ║
║ Finished Quantity? (Y/N) ■ ║
║ ║
║ Do you want a Printed Report? (Y/N) ■ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 17
A prompt will appear prompting you to enter the number of ENDITEMS
to be built. This number defaults to the maximum number that can be built
based on the quantities found in the WIP_QTY field.
╔════[ Assemble: 1.000 ]════════════════════════════════════║
║ ║
║ 1.000 of 8.000 ENDITEMS can be Assembled! ║
║ ║
║ Enter Final Quantity To Be Assembled: 1.000 ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
■ UPDATE INVENTORY WITH FINISHED ENDITEMS
Use this routine when ready to move assembled/finished ENDITEMS back
into the inventory database from the BOM database.
The finished quantity is found in the field: FINIS_QTY.
╔════════════════[ UPDATE INVENTORY WITH FINISHED ENDITEMS ]═════════════════╗
║ Shop Order: 90002 Comment: FOREVER CARE Date: 01/05/91║
║ End Item: CASKET34 Desc: Casket #34 Due: 01/05/91║
║ Qty: 2.000 Assembled: 1.000 Cost: 2050.000 Last Date: 01/19/91║
║ Customer: 18003 Invoice: 4009 Hours: 0.000 Labor: 0.000║
║ Priority: 0 Open: Yes Allocated: Yes Printed: No ║
║ SO COMMENT ENDITEM ║
║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║
║ Shop ->║ 90002 │ FOREVER CARE, INC │ CASKET34 ║
║ Order ║ 90002 │ │ LINER34 ║
║ ║ 90002 │ │ MOURNERSx15 ║
║ ║ 90002 │ │ BIGBURN ║
║ ║ 90003 │ Morgan, Inc │ B33243 ║
║ ║ 90003 │ │ D234 ║
║ U ║ 90003 │ │ A243 ║
║ P ║ 90003 │ │ B23403 ║
║ D ║ 90003 │ │ B32431 ║
║ A ║ 90003 │ │ A233 ║
║ T ║ 90003 │ (See Joe) │ B23401 ║
║ E ║ 90003 │ │ APSBH-2 ║
║ ║ 90003 │ │ C42234 ║
╚═════════════╩══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F5 - F10 (Find)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 18
You can update the inventory for the entire shop order, or the currently
highlighted record (ENDITEM).
╔═══════════════════════════════════════════════════════════════║
║ Select Option -> Update Inventory For Current Record ║
║ Update Inventory For Entire Shop Order ║
║ Exit/Abort ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
A simple report of the operation can be printed out.
╔═══════════════════════════════════════════════════════════════║
║ Select Option -> Update Inventory For Entire Shop Order ║
║ ║
║ Do you want a Printed Report? (Y/N) ■ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
The progress of the operation is displayed onto the screen:
╔═══════════════════════════════════════════════════════════════║
║(Level) Item Per-Qty Req-Qty Transferred ║
║CASKET34 1.000 1.000 1.000 ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╩═══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 19
■ PRINT/REPRINT SHOP ORDER
Shop order can be configured to automatically print upon completion
of adding a new one. Use this routine to print or reprint shop orders.
╔════════════════════════[ PRINT/REPRINT SHOP ORDER ]════════════════════════╗
║ Shop Order: 1022 Comment: Perkins Boats Date: 01/05/91║
║ End Item: ABIGBOAT Desc: BIG BOAT Due: 01/05/91║
║ Qty: 8.000 Assembled: 2.000 Cost: 9100.000 Last Date: 01/19/91║
║ Customer: 1029 Invoice: 1222 Hours: 56.500 Labor: 25.000║
║ Priority: 2 Open: Yes Allocated: Yes Printed: No ║
║ SO COMMENT ENDITEM ║
║ Select ╔═══════════╤════════════════════════════════╤═════════════════║
║ The Shop ->║ 1022 │ Perkins Boats │ BOAT1 ║
║ Order ║ 1022 │ │ BOAT34 ║
║ To ║ 1022 │ │ BOAT40 ║
║ Print ║ 1022 │ │ BOAT55 ║
║ or RePrint ║ 1022 │ │ SAIL32-3 ║
║ ║ 1022 │ │ SAIL40-1A ║
║ R ║ 1022 │ │ JETSKISUZ233 ║
║ E ║ 1023 │ Able Morgan │ D ║
║ P ║ 1023 │ │ A ║
║ R ║ 1023 │ │ BP0003 ║
║ I ║ 1025 │ Harley Limpwrist │ BP0001 ║
║ N ║ 1026 │ Smith, Joe (Green) │ A ║
║ T ║ 1026 │ (Red & Green) │ BP0001 ║
╚═════════════╩══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F5 - F10 (Find) Ctrl F1 (Shop Order Notes)
A window appears onto the screen while it prints the shop order.
╔════════════════════════════════════════════════════════════════════════════╗
║ Shop Order: 2 Original Printing! ║
║ Printing 1 copy of the STANDARD Shop Order on Port: LPT1 ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 20
■ EXAMPLE OF A SHOP ORDER
Shop Order: 2 YOUR COMPANY, INC - SHOP ORDER Page: 1
Date Created: 01/05/91
Customer: 100092 Date Due: 01/19/91
Invoice: 1222 Date Printed: 01/19/91
Cost
ENDITEM Hours
VENDITEM Description/Comment Qty Labor Extended
------------ ------------------------------ ---------- ---------- ----------
BIGCAR BIG CAR 1.000 C 1000.000 1000.000
CAD-1965 CADILAC, OLD JUNK 1.000 H 3.300 3.300
Joe Morgan /// EA L 5.000 5.000
< Allocated >
BP0003 GATOR COFFEE MUG WITH LID 10.000 C 18.500 185.000
BETRAS18 222-GATOR COFFEE MUG WITH LID 18/// EA H 3.700 37.000
Salley Morgan L 5.200 52.000
< Allocated >
DOOR3 DOOR 1.000 C 5.000 5.000
DOOR-JOES 222-DOOR 5/// EA H 3.300 3.300
Jose George Morgan L 3.800 3.800
< Allocated >
------------------------------------------------------------------------------
Special Comments: Totals! Pieces: 18.000
Weight: 0.000
+ Cost: 1190.000
Hours: 43.300
+ Labor: 60.800
+ Labor1: 0.000
+ Labor2: 0.000
--------------------------------
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 21
■ PRINT/REPRINT A TRAVELER
Use this routine to print a Traveler. Note, read more about the traveler
in the configuration options section of this manual.
╔════════════════════════[ PRINT/REPRINT A TRAVELER ]════════════════════════╗
║ Shop Order: 1032 Comment: Joe Morgan Date: 01/05/91║
║ End Item: BIGBIKE Desc: HARLEY 1300CC Due: 01/05/91║
║ Qty: 1.000 Assembled: 0.000 Cost: 12003.000 Last Date: 01/19/91║
║ Customer: 1003 Invoice: 0 Hours: 104.750 Labor: 0.000║
║ Priority: 0 Open: Yes Allocated: Yes Printed: No ║
║ SO COMMENT ENDITEM ║
║ Select the ╔═══════════╤════════════════════════════════╤═════════════════║
║ Shop ->║ 1032 │ Joe Morgan │ BIGBIKE ║
║ Order ║ 1032 │ Joe Morgan │ BIGSEAT ║
║ ║ 1032 │ Joe Morgan │ BIGHELMET ║
║ ║ 1033 │ Carmen, Tony & AJ │ BP0003 ║
║ ║ 1033 │ │ BP0001 ║
║ T ║ 1033 │ │ A2344 ║
║ R ║ 1033 │ │ 4P0001 ║
║ A ║ 1033 │ #4 │ APSBH-12 ║
║ V ║ 1033 │ │ C324342 ║
║ E ║ 1033 │ │ BP02343 ║
║ L ║ 1033 │ #4,red │ APSBH-2 ║
║ E ║ 1033 │ green │ C342342 ║
║ R ║ 1033 │ │ APS3BH-4 ║
╚═════════════╩══════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F5 - F10 (Find)
There are 2 user defined Traveler types to select from:
╔══════════════════════════════════════════════════════════════════════════╗
║ Select Traveler -> Traveler Type 1 ║
║ Traveler Type 2 ║
║ Exit ║
║ ║
║ ║
╚══════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
A window is displayed onto the screen while it prints the report:
╔════════════════════════════════════════════════════════════════════════════╗
║ Select Traveler -> Traveler Type 1 ║
║ ║
║ Traveler: 25 ║
║ ║
║ Printing STANDARD Traveler on Port: LPT1 ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 22
■ EXAMPLE OF A USER DEFINED TRAVELER
TRAVELER YOUR COMPANY, INC Page 1
Type 1 Date: 01/19/91 Time 20:16:28
Item PER QTY Required WIP QTY Dept #1 Dept #2 Dept #3
------------ ---------- ---------- ---------- -------- -------- --------
A24234 0.00 110.00 0.00 ________ ________ ________
APSBH-2 1.00 110.00 0.00 ________ ________ ________
APSBH-1 2.00 220.00 0.00 ________ ________ ________
BP0003 2.00 220.00 0.00 ________ ________ ________
D234432 2.00 220.00 0.00 ________ ________ ________
H234234432 20.00 2200.00 0.00 ________ ________ ________
YK90086 10.00 1100.00 0.00 ________ ________ ________
A423432 1.00 110.00 0.00 ________ ________ ________
APSBH-1 10.00 1100.00 10.00 ________ ________ ________
APSBH-2 2.00 220.00 2.00 ________ ________ ________
B243432 1.00 23.00 7.00 ________ ________ ________
C432324 1.00 24.00 0.00 ________ ________ ________
YK90086 1.00 25.00 0.00 ________ ________ ________
YKEL14 1.00 26.00 0.00 ________ ________ ________
YKEL24 1.00 27.00 0.00 ________ ________ ________
G423432 45.00 28.00 0.00 ________ ________ ________
E40 9.00 29.00 0.00 ________ ________ ________
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 23
■ MAKE SHOP ORDERS FROM BACK ORDERS
This special routine was added for the use of DAYO users that create
invoice back orders for ENDITEMS that are later to be assembled.
If run, all records not deleted, and with the field MRP equal to false
(.F.) will be 'looked at' to determine if it is an ENDITEM, and if so, to
create a shop order for it (New shop order number created for unique invoice
number).
╔═══════════════════[ MAKE SHOP ORDERS FROM BACK ORDERS ]════════════════════╗
║ This routine will make Shop Orders out of all Back Orders that contain a ║
║ manufactured item (defined in the BOM as an ENDITEM). ║
║ ║
║ Only 1 Shop Order per Back Order Invoice (number) will be created. ║
║ ║
║ Do you wish to continue? (Y/N) ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ██▄████░ ▄█████▄ ▄██████░ ▄█████▄ ║
║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░ ██▄ ██░ ██░ ██░ ║
║ ███████░ ██░ ██░ █████████■ ▀█████▄ ██░ ██░ ║
║ ██░ ██░ ██░ ██░ ██▀ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║ ██▀████░■ ▀█████▀■ ██████▀■ ▀█████▀■ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 24
The progress of the operation is displayed with an 'hour glass' type
progress graph:
DAYO MRP Version 3.0 TJS LAB
╔══╔══════════════════════╗ SHOP ORDERS FROM BACK ORDERS ]═══════════════════╗
║ ║ ░░█▀▀▀▀▀▀▀▀▀▀▀▀▀▀█░░ ║hop Orders out of all Back Orders that contain a ║
║ ║ ░░▌ ▐░░ ║ed in the BOM as an ENDITEM). ║
║ ║ ░░▌ ▐░░ ║ ║
║ ║ ░░▌██████████████▐░░ ║ck Order Invoice (number) will be created. ║
║ ║ ░░▌██████████████▐░░ ║ ║
║ ║ ░░▌██████████████▐░░ ║ (Y/N) ║
║ ║ ░░█▄▄▄▄▄▌ ▐▄▄▄▄▄█░░ ║ ║
║ ║ ░░░░░░░░▌██▐░░░░░░░░ ║ ║
║ ║ ░░░░░░░░▌ ▐░░░░░░░░ ║ ║
║ ║ ░░█▀▀▀▀▀▌ ▐▀▀▀▀▀█░░ ║ ║
║ ║ ░░▌100% ▐░░ ║ ║
║ ║ ░░▌80% ██ ▐░░ ║████▄ ▄██████░ ▄█████▄ ║
║ ║ ░░▌60% ▐░░ ║░ ██░ ██░ ██░ ██░ ║
║ ║ ░░▌██████████████▐░░ ║░ ██░ ██▄ ██░ ██░ ██░ ║
║ ║ ░░▌██████████████▐░░ ║░ ██░ █████████■ ▀█████▄ ██░ ██░ ║
║ ║ ░█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█░ ║░ ██░ ██▀ ██░ ██░ ██░ ║
║ ║ ░▌ PROGRESS GLASS ▐░ ║░ ██░ ██░ ██░ ██░ ║
║ ║ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ ║████▀■ ██████▀■ ▀█████▀■ ║
║ ╚══════════════════════╝ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 25
■ FILE MAINTENANCE FOR SHOP ORDERS
Use this routine to permanently remove deleted records from the databases
BOM.DBF and SO.DBF. Shop order notes can also be deleted and removed if
so desired.
╔════════════════════[ FILE MAINTENANCE FOR SHOP ORDERS ]════════════════════╗
║ This routine will remove all closed Shop Orders (OPEN=.F.) from the ║
║ active Shop Orders database (SO.DBF). The records will be placed into ║
║ the Shop Order History database (SOHIST.DBF). ║
║ Deleted records from the BOM database (BOM.DBF) are removed. ║
║ An option exists to delete and remove Shop Order notes from the database: ║
║ SO_NOTES.DBF if the Shop Order has been closed. ║
║ Deleted records in all databases are PERMANENTLY REMOVED, so please be ║
║ VERY careful when running this routine! ║
║ A backup of the databases is highly recommended BEFORE using this routine! ║
║ ║
║ Perform File Maintenance? (Y/N) ║
║ ║
║ Remove Closed Shop Order Notes? (Y/N) ║
║ ║
║███░███░█░ ███░ █▄ ▄█░ █ ███░█░ █░█████░███░█░ █░ █░ █░ █░▄██░███░║
║█░ █░ █░ █░ █▀█▀█░ █▀█░ █░ ██░█░ █░ █░ ██░█░ █▀█░ ██░█░█░ █░ ║
║███░ █░ █░ ██░ █░█░█░ █░█░ █░ ████░ █░ ██░ ████░ █░█░ ████░█░ ██░ ║
║█░ █░ █░ █░ █░█░█░▄█▄█▄ █░ █░██░ █░ █░ █░██░▄█▄█▄ █░██░█░ █░ ║
║█░ █░ █░ █░ █░▀ █░█░ █░ █░ █░▀█░ █░ █░ █░▀█░█░ █░█░▀█░█░ █░ ║
║█░ ███░███░███░ █░ █░█░ █░███░█░ █░ █░ ███░█░ █░█░ █░█░ █░▀██░███░║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 26
■ BILL OF MATERIALS (BOM) BROWSE & MAINTENANCE
This is the browse and maintenance routine for the Bill of Materials
(BOM) database: BOM.DBF. This database is the heart of the MRP application.
From this routine, you can accomplish many MRP process, ie: edit, Add/Define
new ENDITEMS and Bill of Materials, Add new records to existing BOMs,
delete records, resort BOMs, transfer quantities, assemble items, UnAssemble
items, print a Traveler, or find records based on 11 indexes.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄[ Bill of Materials (BOM) Browse & Maintenance ]▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
█ End Item: ABIGCAR Item: WHEELS4 Cost: 986.500 Type: CAR █
█ Description: WHEELS Class: CW Last Date: 01/19/91█
█ Per Qty: 4.000 Required: 28.000 WIP Qty: 8.000 Pos: 1.02 █
█ Mfg PTD: 458.000 Mfg YTD: 4476.000 Assembled: 0.000 █
█ Hours: 0.240 Labor: 1.771 Labor1: 4.148 Labor2: 5.657 █
█ Onhand: 6.000 Onorder: 360.000 Back Order: 10.000 █
█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█
█ ENDITEM DESC COST LEVEL1 █
█──────────────╥────────────────────────────────╥────────────╥───────────────█
█ ABIGCAR ║ BIG CAR ║ 13322.000 ║ █
█ ABIGCAR ║ WHEELS ║ 986.500 ║ WHEELS4 █
█ ABIGCAR ║ INSURANCE ║ 1615.900 ║ CARINS12FUL █
█ APSBH-2 ║ FL NEON KIT ║ 316.528 ║ █
█ APSBH-2 ║ FLORIDA WATER BOTTLE ║ 19.627 ║ BP2690A █
█ APSBH-2 ║ GATOR COFFEE MUG WITH LID ║ 18.594 ║ BP0003 █
█ APSBH-2 ║ NINJA TURTLE BIG MOUTH WTR BTL ║ 23.759 ║ BP4963B █
█ APSBH-2 ║ HANDLE, DOOR ║ 6.198 ║ BP2690A █
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Esc (Exit) F1 (Help) F2 (Edit) F3 (Add/Define New ENDITEM and BOM)
Ctrl N(Add) Ctrl U(Delete/Recall) Ctrl F10(ReSort BOM) Ctrl F1(Reset)
Alt F5 (Transfers) Alt F6 (Assemble) Alt F7 (UnAssemble) Alt P (Print)
F5 (Find) F6 (Change Index) Current Index: ENDITEM
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 27
■ FULL SCREEN EDIT - F2
Press F2 to edit all fields in the database BOM.DBF at once onto the
screen.
┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐
│ ENDITEM: ABIGCAR LASTTIME: 18:27:03 │
│ DESC: WHEELS HOURS: .240 │
│ COST: 986.500 LABOR: 1.771 │
│ LEVEL1: WHEELS4 LABOR1: 4.148 │
│ LEVEL2: LABOR2: 5.657 │
│ LEVEL3: OVERRIDE: F │
│ LEVEL4: POSITION: 1.02 │
│ LEVEL5: │
│ LEVEL6: │
│ LEVEL7: │
│ LEVEL8: │
│ BUILD_QTY: 0.000 │
│ FINIS_QTY: 0.000 │
│ OPEN_QTY: 0.000 │
│ WIP_QTY: 8.000 │
│ REQ_QTY: 28.000 │
│ PER_QTY: 4.000 │
│ PTD_QTY: 458.000 │
│ YTD_QTY: 4476.000 │
│ DATE: 01/05/91 │
│ LASTDATE: 01/19/91 │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 28
■ CREATE A NEW BILL OF MATERIALS (BOM) - F3
Press F3 to create a new Bill of Materials.
╔══════════════════[ CREATE A NEW BILL OF MATERIALS (BOM) ]══════════════════╗
║ ║
║ ITEM DESC ONHAND ║
║ ╔══════════════╤════════════════════════════════╤══════════║
║Select ENDITEM ->║ ABIGCAR │ BIG CAR │ 1.00 ║
║ ║ APSBH-1 │ FL GATOR DELUXE FOAM WTR BOTTL │ 0.00 ║
║ ║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 0.00 ║
║ ██▄██▄██░ ║ B342KIT │ 4-PKT BELLY BAG LEATHER LK │ 0.00 ║
║ ██░██░██░ ║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 174.00 ║
║ ██░██░██░ ║ BP0003 │ GATOR COFFEE MUG WITH LID │ 3505.00 ║
║ ██░ ██░ ║ BP2690A │ FLORIDA WATER BOTTLE │ 610.00 ║
║ ║ BP2690AB │ FLORIDA BIG MOUTH WATER BOTTLE │ 205.00 ║
║ ██▄████░ ║ BP4945B │ NEW KIDS BIG MOUTH WATER BOTTL │ 215.00 ║
║ ██░ ██░ ║ BP4963 │ NINJA TURTLES WATER BOTTLE │ 226.00 ║
║ ██▀▀██▀ ║ BP4963B │ NINJA TURTLE BIG MOUTH WTR BTL │ 237.00 ║
║ ██░ ▀██░ ║ BP5666B │ SIMPSONS WATER BOTTLE │ 246.00 ║
║ ║ BP5666WH │ SIMPSONS PLASTIC MUG │ 234.00 ║
║ ██▄████░ ║ BP7080WH │ GATOR WATER BOTTLE │ 265.00 ║
║ ██░ ██░ ║ C2342 │ PALADINO NYLON 3-PKT BELLY BAG │ 0.00 ║
║ ██▀▀▀▀▀ ║ D142 │ DOOR │ 0.00 ║
║ ██░ ║ E52333 │ HANDLE, DOOR │ 0.00 ║
╚═════════════════╩══════════════════════════════════════════════════════════╝
Esc (Exit) F5 (ITEM) F6 (DESC) F7 (VENDOR) F8 (VENDITEM) F9 (TYPE)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 29
■ ADD COMPONENT ITEMS TO NEW BILL OF MATERIALS (BOM)
After selecting the ENDITEM, you will be given a browse of all inventory
items to select the component items for the ENDITEM.
╔═══════════[ ADD COMPONENT ITEMS TO NEW BILL OF MATERIALS (BOM) ]═══════════╗
║ ║
║ ITEM DESC ║
║ ╔══════════════════╤════════════════════════════════════║
║Select Components ->║ BP2690A │ FLORIDA WATER BOTTLE ║
║ ║ BP2690AB │ FLORIDA BIG MOUTH WATER BOTTLE ║
║For LEVEL1 ║ BP4945B │ NEW KIDS BIG MOUTH WATER BOTTL ║
║ ║ BP4963 │ NINJA TURTLES WATER BOTTLE ║
║ ║ BP4963B │ NINJA TURTLE BIG MOUTH WTR BTL ║
║ █▄██░ ║ BP5666B │ SIMPSONS WATER BOTTLE ║
║ █░ █░ ║ BP5666WH │ SIMPSONS PLASTIC MUG ║
║ █▀▀█░ ║ BP7080WH │ GATOR WATER BOTTLE ║
║ █▀██░ ║ C124324 │ PALADINO NYLON 3-PKT BELLY BAG ║
║ ║ D4142142 │ DOOR ║
║ ████░ ║ E63G43525 │ HANDLE, DOOR ║
║ █░ █░ ║ EV044JW │ DENIM BELLY BAG ║
║ ████░ ║ F354453F │ PALADINO LEATHER LOOK-BLACK BB ║
║ ║ GFF3434 │ CHILDREN'S BELLY BAGS ║
║ █▄█▄█░ ║ H34F34 │ ADULT BELLY BAGS ║
║ █░█░█░ ║ IF3434F43 │ NEON ADULT-4 PKT BELLY BAGS ║
║ █░ █░ ║ J2345324 │ NEON ADULT-2 PKT BELLY BAG ║
╚════════════════════╩═══════════════════════════════════════════════════════╝
Esc (Exit) F5 (ITEM) F6 (DESC) F7 (VENDOR) F8 (VENDITEM) F9 (TYPE)
19/26
The Per Quantity is the basic number/quantity of each item that it
requires to build one (1) ENDITEM. Must be greater than 0 for anything other
than an ENDITEM or SUB ENDITEM.
╔═════════════════════════════════════════════════════════════════════╗
║ Enter Per Quantity: 10 . ║
╚═════════════════════════════════════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 30
If the level1 item is found to be an ENDITEM itself, the progress of the
merging is displayed onto the screen:
╔═════════════[ COMPONENT IS AN ENDITEM, ADDING ITS COMPONENTS ]═════════════╗
║LEVEL1 LEVEL2 LEVEL3 LEVEL4 LEVEL5 LEVEL6 ║
║D11ASD B100112 ║
║D11ASD A100112 APSBH-2 ║
║D11ASD A299112 APSBH-1 ║
║D11ASD A399112 ║
║D11ASD YK90086 ║
║D11ASD H323312 ║
║D11ASD ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
■ ADD ITEM FROM INVENTORY FOR CURRENT BOM - CTRL N
Press Ctrl N to add a BOM record. THE NEW RECORD WILL FALL JUST AFTER
THE CURRENTLY HIGHLIGHTED RECORD.
╔════════════════[ ADD ITEM FROM INVENTORY FOR CURRENT BOM ]═════════════════╗
║ Will Insert New Record Between the following: ║
║ ENDITEM LEVEL1 LEVEL1 DESCRIPTION ║
║ BP2690A BP2690A DOOR ║
║ ************ ************ ************ ****************************** ║
║ BP2690A D2423 D2344 DOOR HANDLE ║
╟────────────────────────────────────────────────────────────────────────────╢
║ ITEM DESC ONHAND ONORDER ║
║════════════════╤════════════════════════════════╤═══════════╤══════════════║
║ ABIGCAR │ BIG CAR │ 1.00 │ 12.00 ║
║ APSBH-1 │ FL GATOR DELUXE FOAM WTR BOTTL │ 0.00 │ 0.00 ║
║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 0.00 │ 58.00 ║
║ B2345 │ 4-PKT BELLY BAG LEATHER LK │ 0.00 │ 12.00 ║
║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 174.00 │ 78.00 ║
║ BP0003 │ GATOR COFFEE MUG WITH LID │ 3505.00 │ 82.00 ║
║ BP2690A │ DOOR │ 610.00 │ 97.00 ║
║ D2344 │ DOOR HANDLE │ 205.00 │ 0.00 ║
║ BP4945B │ NEW KIDS BIG MOUTH WATER BOTTL │ 215.00 │ 0.00 ║
║ BP4963 │ NINJA TURTLES WATER BOTTLE │ 226.00 │ 0.00 ║
║ BP4963B │ NINJA TURTLE BIG MOUTH WTR BTL │ 237.00 │ 0.00 ║
║ BP5666B │ SIMPSONS WATER BOTTLE │ 246.00 │ 0.00 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit/Abort) Enter/Return (Select Item)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 31
After selecting the item, you will be given the option of editing or
changing the different levels that contain item numbers.
╔════════════════[ ADD ITEM FROM INVENTORY FOR CURRENT BOM ]═════════════════╗
║ Will Insert New Record Between the following: ║
║ ENDITEM LEVEL1 LEVEL1 DESCRIPTION ║
║ BP2690A BP2690A DOOR ║
║ ************ ************ ************ ****************************** ║
║ BP2690A D D DOOR HANDLE ║
╟────────────────────────────────────────────────────────────────────────────╢
║ ║
║ Level1: BP4945B ║
║ Level2: ║
║ Level3: ║
║ Level4: ║
║ Level5: ║
║ Level6: ║
║ Level7: ║
║ Level8: ║
║ ║
║ Per Quantity: 0.000 ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit/Abort) Enter/Return (Select Item)
■ DELETE BOM RECORD - CTRL U
Press Ctrl U to mark a record for deletion.
■ RESORT A BOM - CTRL F10
This option resets and rebuilds the PRIORITY field in the database
BOM.DBF.
┌─────────────────────────────────┐
│ Standby, Doing A ReSort! 1.00 │
└─────────────────────────────────┘
■ RESET ITEM FIELD
Press Ctrl F1 to reset the ITEM field on each BOM component record. This
field is useful in determining what ENDITEMS are related to a specific
component item
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 32
■ BOM TRANSFERS TO/FROM INVENTORY ONHAND & BOM WIP_QTY - ALT F5
This option is used to move quantities from the inventory and into
the BOM, Work in Process (WIP), or to move WIP quantity back to the
inventory. Note, inventory adjustments records are created.
╔══════════[ BOM TRANSFERS TO/FROM INVENTORY ONHAND & BOM WIP_QTY ]══════════╗
║ This routine transfers items to/from the Inventory database (INV.DBF) ║
║ ONHAND field and to/from the BOM database (BOM.DBF) WIP_QTY field. ║
║ Note, an Inventory Adjustment record is created for every transaction... ║
║ ENDITEM: BP2690A Desc: MOTOR #32 Cost: 19.627║
║ ITEM: H234234 Desc: TORQUE SHAFT Cost: 9.297║
║ Per Qty: 180.000 Required: 0.000 Wip 0.000 POS: 2.00║
║ Finished: 0.000 Onhand Inventory: 0.000 Last Date: / / ║
║ Fill ALL Required (ONHAND to WIP_QTY) ║
║ Select Fill Required WIP_QTY From ONHAND, This ENDITEM Only ║
║ Transfer Fill Required WIP_QTY From ONHAND, This Record Only ║
║ Option -> ALL Finished QTY to Inventory ║
║ Finished QTY to Inventory For This ENDITEM Only ║
║ Exit ║
║ █▄███░▄███▄ █░ █░ █████░█▄███░ █░ █░ █░▄██▄ ████░████░█▄███░▄██▄ ║
║ █░ █░█░ █░██░██░ █░ █░ █░ ███░ ██░ █░█░ █░ █░ █░ █░█░ ║
║ █░ █░█░ █░█████░ █░ █░ █░ █░█░ ███░█░█░ █░ █░ █░ █░█░ ║
║ █████░█░ █░█░█░█░ █░ █████░ █░█░ █░███░▀██▄ ███░ ███░ █████░▀██▄ ║
║ █░ █░█░ █░█░█░█░ █░ █░██░ ███░ █░ ██░ █░█░ █░ █░██░ █░ ║
║ █░ █░█░ █░█░▀ █░ █░ █░ █▄ █▀ ▀█░█░ ▀█░ █░█░ █░ █░ █▄ █░ ║
║ █▀███░▀███▀ █░ █░ █░ █░ █░█░ █░█░ █░▀██▀ █░ ████░█░ █░▀██▀ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
A progress graph is displayed onto the screen as the routine performs
the action:
╔═╔══════════════════════╗ TO/FROM INVENTORY ONHAND & BOM WIP_QTY ]══════════╗
║ ║ ░░█▀▀▀▀▀▀▀▀▀▀▀▀▀▀█░░ ║tems to/from the Inventory database (INV.DBF) ║
║ ║ ░░▌ ▐░░ ║ the BOM database (BOM.DBF) WIP_QTY field. ║
║ ║ ░░▌██████████████▐░░ ║tment record is created for every transaction... ║
║ ║ ░░▌██████████████▐░░ ║esc: MOTOR #32 Cost: 19.627║
║ ║ ░░▌██████████████▐░░ ║esc: TORQUE SHAFT Cost: 9.297║
║ ║ ░░▌██████████████▐░░ ║quired: 0.000 Wip 0.000 POS: 2.00║
║ ║ ░░█▄▄▄▄▄▌ ▐▄▄▄▄▄█░░ ║nhand Inventory: 0.000 Last Date: / / ║
║ ║ ░░░░░░░░▌ ▐░░░░░░░░ ║ ║
║ ║ ░░░░░░░░▌██▐░░░░░░░░ ║ ║
║ ║ ░░█▀▀▀▀▀▌ ▐▀▀▀▀▀█░░ ║HAND ║
║ ║ ░░▌100% ▐░░ ║ ║
║ ║ ░░▌80% ▐░░ ║ration? (Y/N) ║
║ ║ ░░▌60% ██ ▐░░ ║ ║
║ ║ ░░▌40% ▐░░ ║████░█▄███░ █░ █░ █░▄██▄ ████░████░█▄███░▄██▄ ║
║ ║ ░░▌██████████████▐░░ ║ █░ █░ █░ ███░ ██░ █░█░ █░ █░ █░ █░█░ ║
║ ║ ░█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█░ ║ █░ █░ █░ █░█░ ███░█░█░ █░ █░ █░ █░█░ ║
║ ║ ░▌ PROGRESS GLASS ▐░ ║ █░ █████░ █░█░ █░███░▀██▄ ███░ ███░ █████░▀██▄ ║
║ ║ █▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█ ║ █░ █░██░ ███░ █░ ██░ █░█░ █░ █░██░ █░ ║
║ ╚══════════════════════╝ █░ █░ █▄ █▀ ▀█░█░ ▀█░ █░█░ █░ █░ █▄ █░ ║
║ █▀███░▀███▀ █░ █░ █░ █░ █░█░ █░█░ █░▀██▀ █░ ████░█░ █░▀██▀ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 33
■ ASSEMBLE CURRENT ENDITEM - ALT F6
This routine will create finished ENDITEMS from the component items if
enough required WIP quantity (WIP_QTY) is available. The maximum number
of ENDITEM that can be built is the de facto standard.
╔════════════════════════[ ASSEMBLE CURRENT ENDITEM ]════════════════════════╗
║ This routine will determine the maximum number that can be assembled for ║
║ this ENDITEM. You can adjust that quantity prior to the ASSEMBLING the ║
║ ENDITEM. THIS ROUTINE DOES NOT UPDATE THE SHOP ORDER DATABASE (SO.DBF)! ║
║ ║
║ ENDITEM: BP2690A Desc: MOTOR #3 Cost: 19.627║
║ ITEM: H234 Desc: GEAR #32 Cost: 9.297║
║ Per Qty: 180.000 Required: 0.000 Wip 0.000 POS: 2.00║
║ Finished: 0.000 Onhand Inventory: 79.000 Last Date: / / ║
║ ║
║ ║
║ Continue With Operation? (Y/N) ■ ║
║ ║
║ █░ ▄███▄ ▄███▄ █████░ █░ █░ █▄████░ █░ █████░ ║
║ █▀█░ █░ █░ █░ ██░ ██░ █░ █░ █░ █░ ║
║ █▀ ▀█░ █░ █░ █░ ███▄███░ █░ █░ █░ █░ ║
║ █░ █░ ▀███▄ ▀███▄ ███░ █░███░█░ ██████░ █░ ███░ ║
║ █▄▄▄█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║ ██░ ██░ █░ █░ █░ █░ ▀ █░ █░ █░ █░ █░ ║
║ █░ █░ ▀███▀ ▀███▀ █████░ █░ █░ █▀████░ █████░ █████░ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 34
■ UNASSEMBLE CURRENT ENDITEM - ALT F7
Use this routine to unassemble ENDITEMS into its component items. This
step will sometimes be necessary, since the assembly routine only 'looks at'
component items, ignoring the field FINIS_QTY of component items.
╔═══════════════════════[ UNASSEMBLE CURRENT ENDITEM ]═══════════════════════╗
║ This routine will un-assemble the finished quantity (FINIS_QTY), or the ║
║ ONHAND in the inventory. ║
║ This step is REQUIRED in the DAYO assembly process, since the process ║
║ does not utilize the FINIS_QTY or ONHAND quantities of 'Sub' ENDITEMS. ║
║ ENDITEM: D444 Desc: DOOR Cost: 5.165║
║ ITEM: B234 Desc: DOOR HANDLE Cost: 3.099║
║ Per Qty: 23.000 Required: 23.000 Wip 7.000 POS: 6.00║
║ Finished: 0.000 Onhand Inventory: 0.000 Last Date: 01/19/91 ║
║ ║
║ ║
║ Continue With Operation? (Y/N) ■ ║
║ ║
║ ║
║█░ █░ █░ █░ █░ ▄███▄ ▄███▄ ████░ █░ █░ █▄████░ █░ ████░║
║█░ █░ ██░ █░ ██░ █░ █░ █░ ██░ ██░ █░ █░ █░ █░ ║
║█░ █░ ███░ █░ █▀▀█░ █░ █░ █░ ███▄███░ █░ █░ █░ █░ ║
║█░ █░ █░██░█░ ██░ █░ █░ ▀███▄ ▀███▄ ███░ █░███░█░ ██████░ █░ ███░ ║
║█░ █░ █░ ███░ █▄▄█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║
║█░ █░ █░ ██░ ██░ ██░ █░ █░ █░ █░ ▀ █░ █░ █░ █░ █░ ║
║████▀█░ █░ █░ █░ █░ ▀███▀ ▀███▀ ████░ █░ █░ █▀████░ █████░ ████░║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 35
■ PRINT TRAVELER - ALT P
Press Alt P or Alt T to print out a user defined Traveler report. Note,
read more about Travelers in the configuration section of this manual.
An option will appear requesting you to select from 1 of 2 Traveler
types:
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄[ Bill of Materials (BOM) Browse & Maintenance ]▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
█End Item: D Item: B Cost: 3.099 Type: █
█Description: 4-PKT BELLY BAG LEATHER LK Class: BB Last Date: 01/19/91█
█Per Qty: 23.000 Required: 23.000 WIP Qty: 7.000 Pos: 6.00 █
█Mfg PTD: 7.000 Mfg YTD: 7.000 Assembled: 0.000 █
█Hours: 3.430 Labor: 3.871 Labor1: 4.258 Labor2: 5.806 █
█Onhand: 0.000 Onorder: 12.000 Back Order: 4.000 █
█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█
█ ENDITEM DESC COST LEVEL1 █
█──────────────╥────────────────────────────────╥────────────╥───────────────█
█ D ║ ADULT BELLY BAGS ║ 9.297 ║ H █
█╔══════════════════════════════════════════════════════════════════════════╗█
█║ Select Traveler -> Traveler Type 1 ║█
█║ Traveler Type 2 ║█
█║ Exit ║█
█║ ║█
█╚══════════════════════════════════════════════════════════════════════════╝█
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Esc (Exit) F1 (Help) F2 (Edit) F3 (Add/Define New ENDITEM and BOM)
Ctrl N (Add) Ctrl U (Delete/Recall) Ctrl F10 (ReSort BOM)
Alt F5 (Transfers) Alt F6 (Assemble) Alt F7 (UnAssemble) Alt P (Print)
F5 (Find) F6 (Change Index) Current Index: ENDITEM
■ FIND BOM RECORD F5
Press F5 to find a BOM record based on the current index.
■ CURRENT INDEX - F6
Press F6 to select the current index. Note, there are 11 to select from.
╔════════════════════════════════════╗
║ Select Index -> ENDITEM ║
║ DESCRIPTION ║
║ LEVEL1 ║
║ LEVEL2 ║
║ LEVEL3 ║
║ LEVEL4 ║
║ LEVEL5 ║
║ LEVEL6 ║
║ LEVEL7 ║
║ LEVEL8 ║
║ ENDITEM UNIQUE * ║
╚════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 36
■ REPORTS
There are 21+ reports and routines in this section used to report or
list ENDITEMS, Bill of Materials, Shop Orders, and Inventory Adjustments.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
█ MRP REPORTS/ROUTINES █
█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█
█ End Items List █
█ End Items Expanded #1 █
█ End Items Expanded #2 █
█ BOM ABBRE. Report █
█ BOM Report #1 █
█ BOM Report #2 █
█ BOM Report #3 █
█ BOM ALL (Like #1) █
█ BOM ALL (Like #2) █
█ BOM ALL (Like #3) █
█ BOM Requirements/Short █
█ Shop Order List █
█ Shop Order Expanded #1 █
█ Shop Order Expanded #2 █
█ Shop Order History #1 █
█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█
█ Scroll & Select Option █
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
■ REPORTS/ROUTINES LISTING
End Items List Shop Order List
End Items Expanded #1 Shop Order Expanded #1
End Items Expanded #2 Shop Order Expanded #2
BOM ABBRE. Report Shop Order History #1
BOM Report #1 Shop Order History #2
BOM Report #2 MFG History (INVADJ.DBF)
BOM Report #3 MFG History Single Item
BOM ALL (Like #1) Component/Whereis Item
BOM ALL (Like #2) View Reports On Screen
BOM ALL (Like #3) Configuration Settings
BOM Requirements/Short Allocation Report
Printer Setup
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 37
■ ENDITEMS LIST
This report list all unique ENDITEMS to printer or file. An ENDITEM is
the BOM record that starts a Bill of Material, and contains an empty LEVEL1
field.
╔═════════════════════════════[ ENDITEMS LIST ]═════════════════════════════╗
║ ║
║ This report lists all unique ENDITEMS (in ENDITEM order). ║
║ Uses Report Form: EIRPT.FRM. Width: 80 characters. ║
║ Includes Fields: ENDITEM, DESC, COST, LABOR & HOURS. ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: EILIST.TXT ║
║ ║
╚═══════════════════════════════════════════════════════════════════════════╝
■ ENDITEMS LIST EXAMPLE
Page No. 1 YOUR COMPANY, INC
01/19/91
ENDITEM LISTING
ENDITEM DESCRIPTION COST LABOR HOURS
------------ ------------------------------ ---------- ---------- ----------
AKDK BIG CAR #2 4122.000 3.761 3.220
APSBH-2 FL NEON DELUXE FOAM WTR BOTTLE 16.520 3.782 3.260
BP0001 GATOR & FLORIDA PLASTIC MUGS 17.560 3.824 3.340
BP0003 GATOR COFFEE MUG WITH LID 18.590 3.776 3.250
BP2690A FLORIDA WATER BOTTLE 19.620 0.000 0.000
C3223 PALADINO NYLON 3-PKT BELLY BAG 4.130 3.803 3.300
D452 DOOR 122.000 3.839 3.370
E23444 HANDLE, DOOR 6.190 4.092 3.850
H23423 ADULT BELLY BAGS 9.290 4.008 3.500
I6346434 NEON ADULT-4 PKT BELLY BAGS 10.330 0.000 0.000
J346543 NEON ADULT-2 PKT BELLY BAG 11.360 4.092 3.660
JAR-1 JAR 0.000 3.755 3.210
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 38
■ ENDITEMS EXPANDED REPORT #1
╔══════════════════════[ ENDITEMS EXPANDED REPORT #1 ]═══════════════════════╗
║ ║
║ This report lists all unique ENDITEMS (in ENDITEM order). ║
║ Uses Report Form: EIRPT1.FRM. Width: 131 characters. ║
║ Includes Fields: ENDITEM, DESC, COST, LABOR, HOURS, FINISHED, PTD, YTD, ║
║ DATE & LASTDATE ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: EIRPT1.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
■ ENDITEMS EXPANDED REPORT #2
╔══════════════════════[ ENDITEMS EXPANDED REPORT #2 ]═══════════════════════╗
║ ║
║ This report lists all unique ENDITEMS (in ENDITEM order). ║
║ Uses Report Form: EIRPT2.FRM. Width: 131 characters. ║
║ Includes Fields: ENDITEM, DESC, COST, LABOR, HOURS, FINISHED, ONHAND, ║
║ BO, TYPE, CLASS, and a Comment Space ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: EIRPT2.TXT ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 39
■ ABBREVIATED BILL OF MATERIALS REPORT
This Bill of Materials report is 80 characters wide and can be directed
to printer or file.
Like the rest of the BOM reports for a single ENDITEM, a browse of all
unique ENDITEMS will appear to select from if you press enter on an empty
prompt.
╔══════════════════[ ABBREVIATED BILL OF MATERIALS REPORT ]══════════════════╗
║ ║
║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║
║ ║
║ comprise the selected EndItem. Uses Report Form: FLOW.FRM. Width: 80 char.║
║ ║
║ ENDITEM DESC COST ║
║ ═════════════╤════════════════════════════════╤══════════║
║Select End Item -> A234333 │ BIG CAR │ 2.069║
║ APSBH-2 │ FL NEON DELUXE FOAM WTR BOTTLE │ 16.528║
║ BP0001 │ GATOR & FLORIDA PLASTIC MUGS │ 17.561║
║ BP0003 │ GATOR COFFEE MUG WITH LID │ 18.594║
║ BP2690A │ FLORIDA WATER BOTTLE │ 19.627║
║ Y45RR3 │ PALADINO NYLON 3-PKT BELLY BAG │ 4.132║
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F5 (Find ENDITEM) F6 (Find DESC)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 40
Print options include number of lines per page. The file name (if
the report is directed to a file), will consist of 'BA' and then the left
6 digits of the ENDITEM.
╔══════════════════[ ABBREVIATED BILL OF MATERIALS REPORT ]══════════════════╗
║ ║
║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║
║ ║
║ comprise the selected EndItem. Uses Report Form: FLOW.FRM. Width: 80 char.║
║ ║
║Enter End Item Number: E12345 ║
║ ║
║Enter Maximum Number of Lines Per Page: 55 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: BAE12345.TXT ║
║ ║
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ ABBREVIATED BILL OF MATERIALS REPORT EXAMPLE
Page No. 1 YOUR COMPANY, INC
01/19/91
ABBREVIATED BILL OF MATERIALS (BOM) REPORT
ITEM DESCRIPTION PER QTY REQ QTY WIP QTY
------------ ------------------------------ ---------- ---------- ----------
D1234 DOOR 0.000 18.000 0.000
H25345 ADULT BELLY BAGS 12.000 20.000 0.000
YK90086 TRACKS KIDS TRI-COLOR NEON BB 9.000 22.000 0.000
A23455 BIG CAR 4.000 4.000 0.000
APSBH-1 FL GATOR DELUXE FOAM WTR BOTTL 10.000 10.000 10.000
APSBH-2 FL NEON DELUXE FOAM WTR BOTTLE 4.000 2.000 2.000
B234523 4-PKT BELLY BAG LEATHER LK 3.000 23.000 7.000
C54322 PALADINO NYLON 3-PKT BELLY BAG 4.000 24.000 0.000
YK90086 TRACKS KIDS TRI-COLOR NEON BB 5.000 31.000 0.000
YKEL1 TRACKS LEATHER LOOK BELLY BAG 6.000 26.000 1.000
YKEL2 TRACKS NYLON BELLY BAG 1.000 27.000 0.000
G23453 CHILDREN'S BELLY BAGS 8.000 28.000 0.000
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 41
■ BOM FLOW CHART #1
This report prints the following fields/information about an ENDITEM:
Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity,
Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM,
Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2.
Every BOM item contains the following fields: Item Number, Description,
Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost Each,
Date Added, Last Date Accessed, and Position/ranking in the BOM.
At the end of the report, a summary of the costs, hours, and labor is
printed.
╔═══════════════════════════[ BOM FLOW CHART #1 ]════════════════════════════╗
║ ║
║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║
║ comprise the selected EndItem. This is Not a Report Form. Width: 131 char. ║
║ ║
║ ║
║Enter End Item Number: E1234 ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: BE1234.TXT ║
║ ║
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #1 ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 42
■ BOM FLOW CHART #2
This report prints the following fields/information about an ENDITEM:
Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity,
Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM,
Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2.
Every BOM item contains the following fields: Item Number, Description,
Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost
Extended for Required Quantity, Labor Extended for Required Quantity, and
Hours Extended for Required Quantity.
At the end of the report, a summary of the costs, hours, and labor is
printed.
╔═══════════════════════════[ BOM FLOW CHART #2 ]════════════════════════════╗
║ ║
║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║
║ comprise the selected EndItem. This is Not a Report Form. Width: 131 char. ║
║ Includes the Required Extended COST, LABOR & HOURS fields for each line... ║
║ ║
║Enter End Item Number: E12334 ║
║ ║
║Enter Maximum Number of Lines Per Page: 55 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: BE12334.TXT ║
║ ║
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #2 ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 43
■ BOM FLOW CHART #3
This report prints the following fields/information about an ENDITEM:
Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity,
Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM,
Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2.
Every BOM item contains the following fields: Item Number, Description,
Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost
Extended for WIP Quantity, Labor Extended for WIP Quantity, and
Hours Extended for WIP Quantity.
At the end of the report, a summary of the costs, hours, and labor is
printed.
╔═══════════════════════════[ BOM FLOW CHART #3 ]════════════════════════════╗
║ ║
║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║
║ comprise the selected EndItem. This is Not a Report Form. Width: 131 char. ║
║ Includes the WIP Extended COST, LABOR & HOURS fields for each line... ║
║ ║
║Enter End Item Number: E12344 ║
║ ║
║Enter Maximum Number of Lines Per Page: 55 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: BE12344.TXT ║
║ ║
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #3 ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 44
■ ALL - BOM FLOW CHART #1
This report prints the following fields/information about every ENDITEM:
Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity,
Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM,
Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2.
Every BOM item contains the following fields: Item Number, Description,
Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost Each,
Date Added, Last Date Accessed, and Position/ranking in the BOM.
At the end of the report, a summary of the costs, hours, and labor is
printed.
╔════════════════════════[ ALL - BOM FLOW CHART #1 ]═════════════════════════╗
║ ║
║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║
║ comprise ALL EndItems. This is Not a Report Form. Width: 131 char. ║
║ ║
║ ║
║ ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: BOM1A.TXT ║
║ ║
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ A ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ L ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ L █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #1 ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 45
The progress of this report is displayed onto the screen:
╔═════════════════[ BOM FLOW CHART #1A, FOR ALL ENDITEMS ]═══════════════════╗
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ A ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ L ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ L █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #1 ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
║ENDITEM PER QTY REQ QTY WIP QTY COST POSITION ║
║ APSBH-2 20.000 0.000 0.000 16.528 4.00 ║
║ B4332 230.000 0.000 0.000 3.099 5.00 ║
║ C243432 240.000 0.000 0.000 4.132 6.00 ║
║ YK90086 250.000 0.000 0.000 12.396 7.00 ║
║ YKEL1 260.000 0.000 0.000 13.429 8.00 ║
║ YKEL2 270.000 0.000 0.000 14.462 9.00 ║
║ G324432 280.000 0.000 0.000 8.264 10.00 ║
║ E23423 290.000 0.000 0.000 6.198 11.00 ║
║C234324 10.000 190.000 0.000 4.132 0000000 ║
║YK90086 11.000 209.000 0.000 12.396 0000001 ║
║YKEL1 12.000 228.000 0.000 13.429 0000002 ║
║YKEL2 13.000 247.000 0.000 14.462 0000003 ║
╚════════════════════════════════════════════════════════════════════════════╝
Standby, While I print this report... Press Esc to Abort...
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 46
■ ALL - BOM FLOW CHART #2A
This report prints the following fields/information about every ENDITEM:
Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity,
Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM,
Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2.
Every BOM item contains the following fields: Item Number, Description,
Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost
Extended for Required Quantity, Labor Extended for Required Quantity, and
Hours Extended for Required Quantity.
At the end of the report, a summary of the costs, hours, and labor is
printed.
╔════════════════════════[ ALL - BOM FLOW CHART #2A ]════════════════════════╗
║ ║
║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║
║ comprise ALL EndItems. This is Not a Report Form. Width: 131 char. ║
║ Includes the Required Extended COST, LABOR & HOURS fields for each line... ║
║ ║
║ ║
║ ║
║Enter Maximum Number of Lines Per Page: 55 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: BOM2A.TXT ║
║ ║
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ A ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ L ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ L █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #2 ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 47
■ ALL - BOM FLOW CHART #3A
This report prints the following fields/information about every ENDITEM:
Last Date Accessed, Description, Cost, Required Quantity, Finished Quantity,
Period to Date Quantity, Year to Date Quantity, Hours to Assemble 1 ENDITEM,
Labor to Assemble 1 ENDITEM, Alternate Labor 1, and Alternate Labor 2.
Every BOM item contains the following fields: Item Number, Description,
Per Quantity, Required Quantity, Work In Process (WIP) Quantity, Cost
Extended for WIP Quantity, Labor Extended for WIP Quantity, and
Hours Extended for WIP Quantity.
At the end of the report, a summary of the costs, hours, and labor is
printed.
╔════════════════════════[ ALL - BOM FLOW CHART #3A ]════════════════════════╗
║ ║
║ This Bill of Materials (BOM) Report is a listing of all detail (items) that║
║ comprise the all EndItems. This is Not a Report Form. Width: 131 char. ║
║ Includes the WIP Extended COST, LABOR & HOURS fields for each line... ║
║ ║
║ ║
║ ║
║Enter Maximum Number of Lines Per Page: 55 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: BOM3A.TXT ║
║ ║
║█▄██████░ ▄█████▄ ███░ ███░ ███████░ ██░ ▄█████▄ ██░ ██░║
║██░ ██░ ██░ ██░ ████░ ████░ ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░║
║██░ ██░ ██░ ██░ ██▀████▀██░ A ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ L ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ L █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ #3 ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 48
■ BOM SHORTAGE REPORT
Use this report to get the quantities not yet TRANSFERRED from the
Inventory to WIP to meet the required quantity. The required quantity is
the number of an item required to assemble all ENDITEMS that are to be built.
╔══════════════════════════[ BOM SHORTAGE REPORT ]═══════════════════════════╗
║ ║
║ This report lists the shortages for all BOM items for a selected ║
║ EndItem. This is Not a Report Form. Width: 80 char. ║
║ ║
║ ║
║ENDITEM Selected: D12312 ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: BD12312.TXT ║
║ ║
║█▄██████░ ▄█████▄ ███░ ███░ S ███████░ ██░ ▄█████▄ ██░ ██░ ║
║██░ ██░ ██░ ██░ ████░ ████░ H ██░ ██░ ██░ ██░ ██▄ ▄▄ ▄██░ ║
║██░ ██░ ██░ ██░ ██▀████▀██░ O ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║██░ ██░ ██░ ██░ ██░▀██▀ ██░ R ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║████████░ ██░ ██░ ██░ ██░ ██░ T █████░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ██░ ██░ A ██░ ██░ ██░ ██░ ██░ ████░ ██░ ║
║██░ ██░ ██░ ██░ ██░ ▀▀ ██░ G ██░ ██░ ██░ ██░ █████░ █████░ ║
║█▀██████░ ▀█████▀ ██░ ██░ E ██░ ███████░ ▀█████▀ ██░ ██░ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 49
■ BOM SHORTAGE REPORT EXAMPLE
BOM SHORTAGES for EndItem: <<< D12312 >>> Page 1
Date: 01/19/91 Time: 22:43:44 *Last Date: 01/19/91
(Level) Item Description Req-Qty Short
12345678----------- ------------------------------ ---------- ----------
D12312 DOOR 18.000 18.000
H23423 DOOR HANDLE 20.000 20.000
TRACKS23 TRACKS 22.000 22.000
A243 BIG CAR 42.000 2.000
APSBH-1 WHEELS 10.000 0.000
APSBH-2 INSURANCE 2.000 0.000
C23434 PALADINO NYLON KIT 24.000 2.000
YK90086 TRACKS KIDS TRI-COLOR NEON BB 31.000 1.000
YKEL1 TRACKS LEATHER LOOK BELLY BAG 26.000 6.000
YKEL2 TRACKS NYLON BELLY BAG 27.000 7.000
G234324 CHILDREN'S BELLY BAGS 28.000 28.000
E234423 HANDLE, DOOR 29.000 3.000
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Cost Per End Item: 2,309.788
Cost For Required: 2,445.111
Cost for WIP: 209.699
Cost for Finished: 0.000
Hours Per End Item: 853.480
Hours For Required: 894.480
Hours for WIP: 64.950
Hours for Finished: 0.000
Labor Per End Item: 961.521
Labor For Required: 1,007.892
Labor for WIP: 73.439
Labor for Finished: 0.000
Labor1 Per End Item: 1,057.688
Labor1 For Required: 1,108.696
Labor1 for WIP: 80.782
Labor1 for Finished: 0.000
Labor2 Per End Item: 1,442.234
Labor2 For Required: 1,511.791
Labor2 for WIP: 110.160
Labor2 for Finished: 0.000
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 50
■ SHOP ORDERS LIST
This report simply lists all your shop order records to printer or file.
Unlike previous reports, you can select from 6 indexes (sorts).
The FLAGS field will contain an 'A' if allocated, a 'P' if it has been
printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO'
would denote a shop order has been allocated, printed, and is still open.
╔════════════════════════════[ SHOP ORDERS LIST ]════════════════════════════╗
║ ║
║ This report is a listing of your Shop Orders. ║
║ Uses Report Form: SOLIST.FRM. Width: 80 characters. ║
║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED & FLAGS ║
║ ║
║ Select Index -> Shop Order Number ║
║ Shop Order Comment ║
║ ENDITEM ║
║ ENDITEM Description ║
║ Customer Number ║
║ Invoice Number ║
║ Exit ║
║ ║
║ ███████░ ████████░ ██░ ████░ ███████░ ████████░ ║
║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║ ███████░ ██░ ██░ ██░ ██░ ███████░ ██░ ║
║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║
║ ███████░ ████████░ ███████░ ████░ ███████░ ██░ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) Enter/Return (Select)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 51
■ SHOP ORDERS LIST EXAMPLE
Page No. 1 YOUR COMPANY, INC
01/19/91
SHOP ORDER LISTING
SHOP COMMENT
ORDER ENDITEM DESCRIPTION QTY ASSEMBLED FLAG
------ ------------ ------------------------------ ---------- ---------- ----
** Shop Order: 0
0 JAR-1 1.000 4.000 APO
JAR
0 A 24 342423 4.000 0.000 APO
BIG CAR
** Shop Order: 1
1 JAR-1 54 5.000 0.000 PO
JAR
1 A 234 234 6.000 4.000 APO
BIG CAR
1 C 23 4234 18.000 0.000 APO
PALADINO NYLON 3-PKT BELLY BAG
** Shop Order: 2
2 A 345 345 8.000 1.000 APO
BIG CAR
2 BP0003 234 23423 9.000 0.000 APO
GATOR COFFEE MUG WITH LID
2 D 234 2 34234 23 1.000 0.000 APO
DOOR
** Shop Order: 3
3 A 23423 10.000 0.000 O
BIG CAR
3 BP0003 231 11.000 0.000 O
GATOR COFFEE MUG WITH LID
3 BP0001 34534534 16.000 0.000 O
GATOR & FLORIDA PLASTIC MUGS
** Shop Order: 4
4 A 234 23 12.000 0.000 PO
BIG CAR
** Shop Order: 5
5 BP0001 345 13.000 0.000 O
GATOR & FLORIDA PLASTIC MUGS
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 52
■ SHOP ORDERS EXPANDED #1
This is an expanded report listing the following fields for every shop
order record: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED, Extended COST,
HOURS, LABOR, FLAGS and DATE
The FLAGS field will contain an 'A' if allocated, a 'P' if it has been
printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO'
would denote a shop order has been allocated, printed, and is still open.
╔════════════════════════[ SHOP ORDERS EXPANDED #1 ]═════════════════════════╗
║ ║
║ This report prints out Expanded Shop Order data. ║
║ Uses Report Form: SOLIST1.FRM. Width: 131 characters. ║
║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED ║
║ Extended COST, HOURS, LABOR, FLAGS & DATE ║
║ Index Selected: Shop Order Number ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: SOLIST11.TXT ║
║ ║
║ ████░▄███▄ ████░█░ █░█▄███░ █░ █░ █░█▄███░████░█▄███░ █░█░ ██░ ║
║ █░ █░ █░ █░ █▄ ▄█░█░ █░ █▀█░ ██░ █░█░ █░█░ █░ █░ █░█░ █░ ║
║ █░ █░ █░ █░ █▄█░ █░ █░ █░█░ ███ █░█░ █░█░ █░ █░ █████░ █░ ║
║ ████░█░ █░ ███░ █░ █▀███░ █▄█░ █░███░█░ █░███░ █░ █░ █░█░ █░ ║
║ █░█░ █░ █░ █▀█░ █░ █▀ ▀█░█░ ██░█░ █░█░ █░ █░ █████░ █░ ║
║ █░█░ █░ █░ █▀ ▀█░█░ █░ █░█░ ▀█░█░ █░█░ █░ █░ █░█░ █░ ║
║ ████░▀███▀ ████░█░ █░█░ █░ █░█░ █░█▀███░████░█▀███░ █░█░ ███░ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 53
■ SHOP ORDERS EXPANDED #2
This is an expanded report listing the following fields for every shop
order record: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED COST, FLAGS,
DATE, DUEDATE, CUSTOMER, INVOICE and PRIORITY
The FLAGS field will contain an 'A' if allocated, a 'P' if it has been
printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO'
would denote a shop order has been allocated, printed, and is still open.
╔════════════════════════[ SHOP ORDERS EXPANDED #2 ]═════════════════════════╗
║ ║
║ This report prints out Expanded Shop Order data. ║
║ Uses Report Form: SOLIST1.FRM. Width: 131 characters. ║
║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED COST ║
║ FLAGS, DATE, DUEDATE, CUSTOMER, INVOICE & PRIORITY ║
║ Index Selected: ENDITEM ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: SOLIST23.TXT ║
║ ║
║████░▄███▄ ████░█░ █░█▄███░ █░ █░ █░█▄███░████░█▄███░ █░█░ █████░║
║█░ █░ █░ █░ █▄ ▄█░█░ █░ █▀█░ ██░ █░█░ █░█░ █░ █░ █░█░ █░║
║█░ █░ █░ █░ █▄█░ █░ █░ █░█░ ███ █░█░ █░█░ █░ █░ █████░ █░║
║████░█░ █░ ███░ █░ █▀███░ █▄█░ █░███░█░ █░███░ █░ █░ █░█░ ▄████░║
║ █░█░ █░ █░ █▀█░ █░ █▀ ▀█░█░ ██░█░ █░█░ █░ █░ █████░ █░ ║
║ █░█░ █░ █░ █▀ ▀█░█░ █░ █░█░ ▀█░█░ █░█░ █░ █░ █░█░ █░ ║
║████░▀███▀ ████░█░ █░█░ █░ █░█░ █░█▀███░████░█▀███░ █░█░ █████░║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 54
■ SHOP ORDERS HISTORY #1
This is an expanded report listing the following fields for every shop
order history record: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED,
Extended COST, HOURS, LABOR, FLAGS and DATE
The FLAGS field will contain an 'A' if allocated, a 'P' if it has been
printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO'
would denote a shop order has been allocated, printed, and is still open.
All data in the database SOHIST.DBF can be printed out, or those
records that fall between a start and ending date, or records for a specific
customer number, a specific invoice number, a specific shop order number, or
for a specific ENDITEM.
╔═════════════════════════[ SHOP ORDERS HISTORY #1 ]═════════════════════════╗
║ ║
║ This report prints out Expanded Shop Order History data. ║
║ Uses Report Forms: SOHIST1x.FRM. Width: 131 characters. ║
║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED ║
║ Extended COST, HOURS, LABOR, FLAGS & DATE ║
║ Select Option -> Report All ║
║ Date Range ║
║ Specific Customer Number ║
║ Specific Invoice Number ║
║ Specific Shop Order Number ║
║ Specific ENDITEM ║
║ Exit ║
║ ║
║████░ ▄███▄ 1 █░ █░ ███░ ████░ █████░ ▄███▄ █▄███░ █░ █░ █░█░ ██░ ║
║█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █▄ ▄█░ █░█░ █░ ║
║█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █████░ █░ ║
║████░ █░ █░ █████░ █░ ████░ █░ █░ █░ █▄▄▄█░ ▀█▀ █░█░ █░ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░▀█░ █░ █████░ █░ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ██░ █░ █░█░ █░ ║
║████░ ▀███▀ █░ █░ ███░ ████░ █░ ▀███▀ █░ █░ █░ █░█░ ███░║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) Enter/Return (Select)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 55
■ SHOP ORDERS HISTORY #2
This is an expanded report listing the following fields for every shop
order history record: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED,
COST EACH, FLAGS, DATE, DATE DUE, CUSTOMER, INVOICE and PRIORITY
The FLAGS field will contain an 'A' if allocated, a 'P' if it has been
printed, and either an 'O' for Open or 'C' for Closed. For example, 'APO'
would denote a shop order has been allocated, printed, and is still open.
All data in the database SOHIST.DBF can be printed out, or those
records that fall between a start and ENDING date, or records for a specific
customer number, a specific invoice number, a specific shop order number, or
for a specific ENDITEM.
╔═════════════════════════[ SHOP ORDERS HISTORY #2 ]═════════════════════════╗
║ ║
║ This report prints out Expanded Shop Order History data. ║
║ Uses Report Forms: SOHIST2x.FRM. Width: 131 characters. ║
║ Includes the fields: SO, ENDITEM, COMMENT, DESC, QTY, ASSEMBLED ║
║ COST EACH, FLAGS, DATE, DATE DUE, CUSTOMER, INVOICE and PRIORITY ║
║ Option Selected: Report All ║
║ ║
║ Index Selected: Shop Order Number ║
║ ║
║Enter Maximum Number of Lines Per Page: 66 ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║Enter File Name: SOHIST21.TXT ║
║████░ ▄███▄ 2 █░ █░ ███░ ████░ █████░ ▄███▄ █▄███░ █░ █░ █░█░ ████░ ║
║█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █▄ ▄█░ █░█░ █░ ║
║█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░█░ █████░ █░ ║
║████░ █░ █░ █████░ █░ ████░ █░ █░ █░ █▄▄▄█░ ▀█▀ █░█░ ▄▄▄█░ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░▀█░ █░ █████░ █░ ║
║ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ██░ █░ █░█░ █░ ║
║████░ ▀███▀ █░ █░ ███░ ████░ █░ ▀███▀ █░ █░ █░ █░█░ ████░ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 56
■ MANUFACTURING HISTORY REPORT
This is a report of your inventory adjustments required for use in the
MRP process. All records in the database INVADJ.DBF that contain the string
'MRP' in the comment field will be printed out that fall with the start and
ending dates (inclusive) prompt.
Fields included in the report: Item, Description, Qty Adjusted, Cost
Each, Reason for the adjustment (which is computer generated in MRP), Date
of the adjustment, and the Class Code.
┌────────────────────────────────────────────────────────┐
│ The Manufacturing History Report list all records │
│ from the inventory adjustments database (INVADJ.DBF) │
│ that have been created by DAYO MRP ("MRP"$REASON). │
│ Uses Report Form: MFG_HIST.FRM. (126 Wide) │
│ │
│ Start Date: 12/20/90 Ending Date: 01/19/91 │
│ │
│ Enter Heading: YOUR COMPANY, INC │
│ │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ │
│ Enter File Name: MFG_HIST.TXT │
│ │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 57
■ MANUFACTURING HISTORY FOR A SINGLE ITEM REPORT
This is a report of your inventory adjustments required for use in the
MRP process for a specific item. All records in the database INVADJ.DBF for
the selected item, that contain the string 'MRP' in the comment field will
be printed out that fall with the start and ending dates (inclusive) prompt.
Fields included in the report: Item, Description, Qty Adjusted, Cost
Each, Reason for the adjustment (which is computer generated in MRP), Date
of the adjustment, and the Class Code.
┌────────────────────────────────────────────────────────┐
│ The Manufacturing History For A Single Item Report │
│ list all records from the inventory adjustments │
│ database (INVADJ.DBF) for a single Item that have │
│ been created by DAYO MRP ("MRP"$REASON). │
│ Uses Report Form: MFG_HIST.FRM. (126 Wide) │
│ │
│ Report History on Item Number: E │
│ │
│ Start Date: 12/20/90 Ending Date: 01/19/91 │
│ │
│ Enter Heading: YOUR COMPANY, INC │
│ │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ │
│ Enter File Name: HE1234.TXT │
│ │
│ │
│ │
│ │
└────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 58
■ COMPONENT/WHEREIS ITEM REPORT
This report lists all BOM records listing the component item and its
corresponding ENDITEM. Useful in determining which ENDITEMs relate to a
specific component item.
┌────────────────────────────────────────────────────────┐
│ The Component/Whereis Item Report lists all ENDITEMS │
│ that are related to a specific component Item. This │
│ report is indexed on the ITEM field in the database │
│ BOM.DBF. Uses Report Form: WHEREIS.FRM (80 Wide) │
│ │
│ Enter Heading: YOUR COMPANY, INC │
│ │
│ Send Output to Printer? (Y/N) ( No -> To File) │
│ │
│ Enter File Name: WHEREIS.TXT │
│ │
└────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 58.1
■ ALLOCATION REPORT
This is a Purchase Advice report listing all component items with the
required quantity as of the DUEDATE.
The required quantity value is computed as the current ONHAND minus the
total REQ_QTY (in BOM.DBF) as of each DUEDATE.
Two indexes are available: ITEM+DUEDATE and DUEDATE+ITEM
Fields included in the report: Item, Description, Vendor, Due Date and
the Required Quantity (by DUEDATE).
Note, this report can be slow, depending on the number of records in your
BOM and Shop Order databases...
╔═══════════════════════════[ ALLOCATION REPORT ]════════════════════════════╗
║ ║
║ This report lists the sum of all allocated items by DUEDATE. ║
║ Fields Listed: DUEDATE, ITEM, DESC, VENDOR & REQ_QTY. ║
║ The REQ_QTY value is computed as the ONHAND minus Total Required as of the ║
║ the DUEDATE (on the Shop Order). The report can be indexed by: ║
║ ITEM+DUEDATE or DUEDATE+ITEM... (Note, this report can be slow...) ║
║ ║
║ Select Index -> ITEM+DUEDATE ║
║ Enter Maximum Number of Lines Per Page: 66 ║
║ Send Output to Printer? (Y/N) ( No -> To File) ║
║ Enter File Name: ALLOCATE.TXT ║
║DUEDATE ITEM DESCRIPTION VENDOR REQ QTY║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 59
■ VIEW REPORTS ON SCREEN
This routine was provided to aid the 'fight to stop the cutting down of
trees in the world' by offering you the option to view your reports on your
screen. The only limitation is on the size of the report. No reports can be
viewed if they are over 32,000 bytes. (Just kidding about those trees...)
Due to compiler problems (handling of memory), this routine tends to
'hang' your computer. It is not recommended you use this option if your
machine is performing multitasking programs.
At the first prompt, type and enter the name of the report you wish to
view.
╔════════════════════════════════════════════════════════════════════════╗
║Use this option to view any report written to disk. ║
║Press Enter/Return on an empty prompt to display all files with the ║
║extension of '.TXT'. ║
║File size limited to 32,000 bytes. ║
║ ║
║Enter Report File Name to View On Screen: ║
║ ║
╚════════════════════════════════════════════════════════════════════════╝
If the file does not exist, or you press enter on an empty prompt, a
window will appear showing all reports in the current directory. It is
assumed that all reports will have the extension of '.TXT', which is the
DAYO standard.
All reports are displayed in the window, even if they are too large...
╔═══════════════════════════════════════╗
║ File Name Size Date Used ║
╟──────────────┬────────────┬───────────╢
║DAYOERR.TXT │ 270 │ 06/14/90 ║
║CONFIG.TXT │ 861 │ 06/17/90 ║
║EI_RPT1.TXT │ 1097 │ 06/17/90 ║
║EI_RPT2.TXT │ 1742 │ 06/17/90 ║
║EI_RPT3.TXT │ 858 │ 06/17/90 ║
║BOM_RPT1.TXT │ 2190 │ 06/17/90 ║
║BOM_RPT2.TXT │ 3427 │ 06/17/90 ║ ┌────────────────────────┐
║BOMSHORT.TXT │ 783 │ 06/17/90 ║ │ Highlight the Report │
║HJAR-1.TXT │ 1 │ 06/13/90 ║ │ using the UP or Down │
║BBOX.TXT │ 6263 │ 06/17/90 ║ │ arrow keys, then press │
║BOM_ALL.TXT │ 0 │ 06/17/90 ║ │ Enter/Return. │
║MFG_HIST.TXT │ 37089 │ 06/17/90 ║ └────────────────────────┘
║HBOX.TXT │ 2181 │ 06/17/90 ║
║BOM_XXX.TXT │ 24549 │ 06/13/90 ║
║BBOX1.TXT │ 1535 │ 06/13/90 ║
║BOM_ALL1.TXT │ 6127 │ 06/14/90 ║
╚══════════════╧════════════╧═══════════╝
Esc (Exit/Abort)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 60
■ REPORT VIEWING SCREEN
The report viewing screen uses the complete screen. The top line
displays the report name. The bottom lines show you the function keys,
all 2 of them. Also displayed at the bottom of the screen is the current
row/column of the cursor position.
DAYOMRP View Reports │ File Name: BOM_RPT2.TXT
06/17/90
Bill of Materials
BOM Expanded Report (BOM2A.
Subtotal on End Item
Onhand Available
Per Set Required
End Item Item Description Qty Qty
------------ ------------ ------------------------------ ------- --------
** End Item: BOX
BOX JAR-1 Sample Item Description #1 2 0
BOX JAR-1 Sample Item Description #1 0 0
BOX LID Jar Lid 2 0
** Subtotal **
4 0
** NEnd Item: JAR-1
JAR-1 JAR-3 Sample Item Description #3 2 0
JAR-1 LID Jar Lid 2 0
Esc (Exit) F1 (Help)
3/34
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 61
■ CONFIGURATION STATUS REPORT
All configuration options for DAYO MRP can be found in this report.
╔═══════════════════════════════════════════════════════╗
║The Configuration Status Settings Report lists all of ║
║configuration settings (found in file DAYOMRP.CFG). ║
║This is Not a Report Form. ║
║ ║
║Send Output to Printer? (Y/N) ( No -> To File) ║
║ ║
║Enter File Name: CONFIG.TXT ║
╚═══════════════════════════════════════════════════════╝
■ EXAMPLE OF THE CONFIGURATIONS SETTINGS REPORT
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ DAYO MATERIALS REQUIREMENT II PLANNING CONFIGURATION REPORT +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
01/19/91
22:46:42
Company Name: YOUR COMPANY, INC
Address Line 1: Attn: Manufacturing
Address Line 2: P.O. BOX 5555
City, State Zip: Anycity, ST 555555-5555
Telephone: 800-555-5555
Allow Browse Editing: Yes
Use Unique MRP Class Codes: Yes
Take From Inventory CLASS: MRP
Finished goods CLASS: FIN
WIP Put Back CLASS: WIP
WIP Into MRP CLASS: TAK
DisAssemble ENDITEM CLASS: DIS
Inventory Database Location: \DAYOINV\
Current Database Location:
Back Orders Location: \DAYOBO\
Shop Orders Type: STANDARD PRINTER
Shade Laser Shop Orders: Yes
Auto Print Shop Orders: Yes
Shop Orders Copies: 1
Shop Orders Printer Port: LPT1
Last Shop Order Number: 4000
Print DueDate on Shop Order: No
Travelers Type: STANDARD PRINTER
Travelers Printer Port: LPT1
Last Traveler Number: 5521
Skip Page On Traveler: No
Report Printer Type: STANDARD PRINTER
Report Printer Port: LPT1
Visual Indexing: Yes
Automatically Reindex Daily: Yes
Color: Yes
High Intensity: Yes
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 62
■ PRINTER DRIVER (SETUP)
This routine was added to preclude you from having to get out of your
seat to change (mess with) the printer to get it to print correctly.
The most important printer selections (ie: font size, lines per inch,
orientation, ...) are made easy to evoke.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
║ ║
║ Select Option -> Eject ║
║ Line feed ║
║ Normal Size ║
║ Use this routine to set your Small/Condensed ║
║ printer up with one or more Bold On ║
║ of the setup strings and Bold Off ║
║ commands listed to the right. 6 Lines per Inch ║
║ 8 Lines per Inch ║
║ Select the 'Change Printer Print Landscape (Laser Only) ║
║ Default' option to change Print Portrait (Laser Only) ║
║ printer types. Reset Printer ║
║ Current printer is set to: Print Special String 1 ║
║ Okidata Print Special String 2 ║
║ Print Special String 3 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit)
■ PRINTER DRIVER OPTIONS
There are 18 printer driver options to select from. The last option is
to set the default printer, and the next to last is a 'SHELL' function that
runs a DOS command or program. The remainder are strings/codes that are sent
to the printer.
Eject Print Portrait (Laser Only)
Line feed Reset Printer
Normal Size Print Special String 1
Small/Condensed Print Special String 2
Bold On Print Special String 3
Bold Off Print Special String 4
6 Lines per Inch Print Special String 5
8 Lines per Inch Run DOS Command/Program
Print Landscape (Laser Only) Change Default Printer
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 63
■ CHANGE DEFAULT PRINTER
The last option is to change/set the default printer. This printer
driver routine comes with 4 default printer types, Epson, HP Laser, Star,
and Okidata.
You can add (Ctrl N) as many as you want.
╔════════════════════════════════════════════════════════════════════════════╗
║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║
║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║
║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║
║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║
║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║
║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║
╟────────────────────────────────────────────────────────────────────────────╢
║ Current Default Printer is set to: Okidata ║
╟────────────────────────────────────────────────────────────────────────────╢
║ NAME LINEFEED ║
║─────────────────────────────────────╥──────────────────────────────────────║
║ Epson & Compatibles ║ CHR(10) ║
║ HP Laser & Compatibles ║ CHR(10) ║
║ Star Micro Gemini ║ CHR(10) ║
║ Okidata ║ CHR(10) ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
║ ║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add)
1/4
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 64
■ FULL SCREEN EDIT - F2
When entering the printer codes, the string must be in the valid format
or it will not be printed later when requested...
┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐
│ NAME: Epson & Compatibles │
│ LINEFEED: CHR(10) │
│ NORMAL: CHR(27)+CHR(18) │
│ SMALL: CHR(27)+CHR(15) │
│ BOLDON: CHR(27)+CHR(69) │
│ BOLDOFF: CHR(27)+CHR(70) │
│ _6LPI: CHR(27)+CHR(50) │
│ _8LPI: CHR(27)+CHR(48) │
│ PORTRAIT: │
│ LANDSCAPE: │
│ RESET: CHR(27)+CHR(64) │
│ SPEC_STR1: │
│ SPEC_STR2: │
│ SPEC_STR3: │
│ SPEC_STR4: │
│ SPEC_STR5: │
│ RUN_CMD: │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
Press Esc to Abort, PgUp/PgDn to Save and Exit
■ PRINTER DRIVER DATABASE FIELD DEFINITIONS
NAME - Name of printer. Type in anything you wish here
LINEFEED - Code to advance printer one line
NORMAL - Normal font/character size
SMALL - Small font/character size
BOLDON - Bold/Emphasized
BOLDOFF - Bold/Emphasized off
_6LPI - Code to set printer to print 6 lines per inch
_8LPI - Code to set printer to print 8 lines per inch
PORTRAIT - Code to set laser printer to print upright (normal)
LANDSCAPE - Code to set laser printer to print sideways
RESET - Reset printer code
SPEC_STR1 - Any special printer string, ie: print double, skip perforation,
SPEC_STR2 - print very tiny, ...
SPEC_STR3 - "
SPEC_STR4 - "
SPEC_STR5 - "
RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ...
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 65
■ CONFIGURATION
The Configuration Menu/Routine contains all the option settings for
this application. To change any of the 30+ options, arrow down/up to it,
then press enter.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
█ CONFIGURATION █
█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█
█ Company Name █
█ Company Address █
█ Company Telephone █
█ CLASS Codes for MRP █
█ Allow Browse Editing █
█ Inventory Location █
█ Back Orders Location █
█ Customers/AR Location █
█ POS Location █
█ Current Directory █
█ Report Printer Type █
█ Report Printer Port █
█ Visual Indexing █
█ Auto Daily Indexing █
█ Auto Print Shop Order █
█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄█
█ Select Option █
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
■ CONFIGURATION OPTIONS LISTING
Company Name Visual Indexing
Company Address Auto Daily Indexing
Company Telephone Auto Print Shop Order
CLASS Codes for MRP Shop Order Type
Allow Browse Editing Print Duedate on SO
Inventory Location Shop Order Copies
Back Orders Location Shop Order Port
Customers/AR Location Last Shop Order #
POS Location Traveler Type
Current Directory Traveler Port
Report Printer Type Last Traveler #
Report Printer Port Skip Page - Travelers
Visual Indexing Traveler Setup
Auto Daily Indexing Color
Auto Print Shop Order High Intensity
GL Location Automatic GL Posting
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 66
■ COMPANY NAME
┌───────────────────────────────[ COMPANY NAME ]─────────────────────────────┐
│ Enter Your Company Name: YOUR COMPANY, INC │
└────────────────────────────────────────────────────────────────────────────┘
■ COMPANY ADDRESS
┌─────────────────────────────[ COMPANY ADDRESS ]────────────────────────────┐
│ Address Line 1: Attn: Manufacturing │
│ Address Line 2: P.O. BOX 5555 │
│ City, State ZIP: Anycity, ST 555555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
■ COMPANY TELEPHONE
┌────────────────────────────[ COMPANY TELEPHONE ]───────────────────────────┐
│ Enter Your Company Telephone: 800-555-5555 │
└────────────────────────────────────────────────────────────────────────────┘
■ MRP CLASS CODES
Class Codes (CLASS fields) are used in conjunction with DAYO General
Ledger. If you are not using General Ledger, then this routine need not
be maintained...
If DAYO GL is being used, you have the option of differentiating between
the many types of inventory adjustments required in an MRP process. For
example, inventory items taken from inventory and place into WIP will have
a different CLASS Code (in the adjustments records), than from assembled
ENDITEMS placed into inventory.
┌────────────────────────────[ MRP CLASS CODES ]────────────────────────────┐
│ The Materials Requirement Planning (MRP) process posts all its │
│ transactions of inventory adjustments to the file INVADJ.DBF. │
│ For General Ledger to work properly, these transactions must contain a │
│ valid CLASS code. │
│ │
│ The Options Are: │
│ 1. Make all categories of adjustments unique, ie: │
│ MRP - Taken from Inventory by MRP process │
│ FIN - Finished goods put into inventory after being manufactured │
│ WIP - Work in process items put back into inventory by adjustment │
│ TAK - Work in process items brought into MRP from inventory by │
│ Adjustment │
│ DIS - Disassembled ENDITEMs in BOM.DBF and/or INV.DBF │
│ or │
│ 2. CLASS Codes remain the same as in the Inventory Database (INV.DBF)│
│ │
│ The default is Option 1: Make all categories of adjustments unique using│
│ the CLASS Codes displayed on the above lines. │
│ │
│ Select Option -> CLASS Codes are unique (the default) │
│ CLASS Codes remain the same as in the Inventory │
└───────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 67
■ ALLOW BROWSE EDITING
┌───────────────────────────[ ALLOW BROWSE EDITING ]─────────────────────────┐
│ To disable editing while in a browse screen, select N (NO) to this │
│ option. Default is to allow it. │
│ │
│ Allow Editing While In A Browse Screen? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ INVENTORY LOCATION/DIRECTORY
┌───────────────────────[ INVENTORY LOCATION/DIRECTORY ]─────────────────────┐
│ The location of the DAYO Inventory (INV.DBF) does not have to be in the │
│ same drive/directory as DAYO MRP. If you have installed DAYO Inventory │
│ into a different directory, you need to tell DAYO MRP where to find │
│ the inventory database (INV.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOINV\ │
│ The drive designation is optional (if same as DAYO MRP). │
│ │
│ Enter Location: \DAYOINV\ │
└────────────────────────────────────────────────────────────────────────────┘
■ BACK ORDERS LOCATION/DIRECTORY
┌──────────────────────[ BACK ORDERS LOCATION/DIRECTORY ]────────────────────┐
│ The location of the DAYO Back Orders (BO.DBF) does not have to be in the │
│ same drive/directory as DAYO MRP. If you have installed DAYO BO │
│ into a different directory, you need to tell DAYO MRP where to find │
│ the back orders database (BO.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOBO\ │
│ The drive designation is optional (if same as DAYO MRP). │
│ │
│ Enter Location: \DAYOBO\ │
└────────────────────────────────────────────────────────────────────────────┘
■ CUSTOMERS (AR) LOCATION/DIRECTORY
┌────────────────────[ CUSTOMERS (AR) LOCATION/DIRECTORY ]───────────────────┐
│ The location of the DAYO Customer database does not have to be in │
│ the same drive/directory as DAYO MRP. If you have installed DAYO AR │
│ into a different directory, you need to tell DAYO MRP where to find │
│ the customer database (CUSTOMER.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOAR\ │
│ The drive designation is optional (if same as DAYO MRP). │
│ │
│ Enter Location: \DAYOAR\ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 68
■ POINT OF SALE (POS) LOCATION/DIRECTORY
┌──────────────────[ POINT OF SALE (POS) LOCATION/DIRECTORY ]────────────────┐
│ The location of the DAYO POS Invoice database does not have to be in the │
│ same drive/directory as DAYO MRP. If you have installed DAYO POS │
│ into a different directory, you need to tell DAYO MRP where to find │
│ the invoice database (INVOICE.DBF). Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOPOS\ │
│ The drive designation is optional (if same as DAYO MRP). │
│ │
│ Enter Location: \DAYOPOS\ │
└────────────────────────────────────────────────────────────────────────────┘
■ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY
┌────────────[ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ]─────────────┐
│ The location of DAYO General Ledger Databases does not have to be │
│ in the same drive/directory as this module. If you have installed DAYO GL │
│ into a different directory, you need to tell this module where to find │
│ the GL databases. Default is nil (current directory). │
│ Be sure to include the rightmost slash, ie: \DAYOGL\ │
│ The drive designation is optional (if same as this module). │
│ │
│ Enter Location: \DAYOGL\ │
└────────────────────────────────────────────────────────────────────────────┘
■ CURRENT DIRECTORY DATABASE LOCATION
┌───────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]──────────────────┐
│ This module's databases can be located in a different location other │
│ than the current directory. If you have and wish to use ALL the │
│ databases currently found in this directory from a different drive and │
│ directory, then you need to tell this module where to find them. │
│ Be sure to include the rightmost slash, ie: L:\DAYOPOS\ │
│ The drive designation is optional if same as this module. │
│ │
│ Enter Location: │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORT PRINTER TYPE
┌───────────────────────────[ REPORT PRINTER TYPE ]──────────────────────────┐
│ Routine reports are printed according to this selection. │
│ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │
│ The LASER printer type is a Hewlett Packard Laser compatible printer. │
│ Special Laser codes are sent to the LASER option. │
│ │
│ Enter Your Report Printer Type -> STANDARD │
│ LASER │
└────────────────────────────────────────────────────────────────────────────┘
■ REPORT PRINTER PORT
┌───────────────────────────[ REPORT PRINTER PORT ]──────────────────────────┐
│ Enter Your Report Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 69
■ VISUAL INDEXING
┌─────────────────────────────[ VISUAL INDEXING ]────────────────────────────┐
│ If you desire to see a progress graph each time your indexes are │
│ created, then select Y (YES). Note, the process can slow the indexing │
│ routine down; especially with larger databases. │
│ │
│ Do you wish to have Visual Indexing? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ AUTOMATIC DAILY INDEXING
┌─────────────────────────[ AUTOMATIC DAILY INDEXING ]───────────────────────┐
│ If this option is set to Y (YES), then all DAYO Indexes accessed by │
│ DAYO MRP will be recreated once daily. This will occur when the first │
│ DAYO MRP program is run. The default is to recreate all the indexes. │
│ │
│ Recreate all DAYO MRP Indexes? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ AUTOMATICALLY PRINT SHOP ORDERS WHEN CREATED
┌───────────────[ AUTOMATICALLY PRINT SHOP ORDERS WHEN CREATED ]─────────────┐
│ If you want your Shop Orders to automatically print after creation, then│
│ change this option to Y (YES). │
│ Default is NOT to automatically print the Shop Orders. │
│ │
│ Automatically Print Shop Orders? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ SHOP ORDER PRINTER TYPE
┌─────────────────────────[ SHOP ORDER PRINTER TYPE ]────────────────────────┐
│ There are 3 types of DAYO Shop Orders: STANDARD, LASER, and DATA ONLY. │
│ The STANDARD Shop Order prints standard characters with headings. │
│ The LASER Shop Order prints small, but with more data onto a Hewlett │
│ Packard (tm) compatible laser printer. │
│ The DATA ONLY Shop Order is the same as the STANDARD with the exception │
│ of the headings (for use with pre-printed forms). │
│ │
│ Enter Your Shop Order Printer Type -> STANDARD │
│ LASER │
│ DATA ONLY │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 70
■ SHOP ORDER PRINTER TYPE
┌─────────────────────────[ SHOP ORDER PRINTER TYPE ]────────────────────────┐
│ There are 3 types of DAYO Shop Orders: STANDARD, LASER, and DATA ONLY. │
│ The STANDARD Shop Order prints standard characters with headings. │
│ The LASER Shop Order prints small, but with more data onto a Hewlett │
│ Packard (tm) compatible laser printer. │
│ The DATA ONLY Shop Order is the same as the STANDARD with the exception │
│ of the headings (for use with pre-printed forms). │
│ │
│ Enter Your Shop Order Printer Type -> STANDARD │
│ LASER │
│ │
│ Do you wish to shade every other line item? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ PRINT DUEDATE ON SHOP ORDER
┌───────────────────────[ PRINT DUEDATE ON SHOP ORDER ]──────────────────────┐
│ If you wish to print the DUEDATE for each ENDITEM on the Shop Orders, │
│ then select Y (YES) to this option. The DUEDATE will print under the │
│ ENDITEM & VENDITEM. The default is not to print the DUEDATE... │
│ │
│ Do you wish to print the DUEDATE onto the Shop Order? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ NUMBER OF SHOP ORDER COPIES TO PRINT
┌───────────────────[ NUMBER OF SHOP ORDER COPIES TO PRINT ]─────────────────┐
│ This option determines the number of Shop Order copies to print at the │
│ time of printing. Default is to print one copy of the Shop Order. │
│ │
│ Enter Number of Shop Order Copies: 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ SHOP ORDER PRINTER PORT
┌─────────────────────────[ SHOP ORDER PRINTER PORT ]────────────────────────┐
│ Enter Your Shop Order Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ LAST SHOP ORDER NUMBER
┌──────────────────────────[ LAST SHOP ORDER NUMBER ]────────────────────────┐
│ Enter Last Shop Order Number: 39 │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 71
■ TRAVELER PRINTER TYPE
┌──────────────────────────[ TRAVELER PRINTER TYPE ]─────────────────────────┐
│ There are 2 types of DAYO Travelers: STANDARD and LASER. │
│ │
│ The LASER Traveler prints sideways and with 10 CPI, onto a Hewlett │
│ Packard (tm) compatible laser printer. │
│ │
│ Enter Your Traveler Printer Type -> STANDARD │
│ LASER │
└────────────────────────────────────────────────────────────────────────────┘
■ TRAVELER PRINTER PORT
┌──────────────────────────[ TRAVELER PRINTER PORT ]─────────────────────────┐
│ Enter Your Traveler Printer Port (1,2,3): 1 │
└────────────────────────────────────────────────────────────────────────────┘
■ LAST TRAVELER NUMBER
┌───────────────────────────[ LAST TRAVELER NUMBER ]─────────────────────────┐
│ Enter Last Traveler Number: 19 │
└────────────────────────────────────────────────────────────────────────────┘
■ SKIP PAGE BETWEEN ENDITEMS ON THE TRAVELERS
┌───────────────[ SKIP PAGE BETWEEN ENDITEMS ON THE TRAVELERS ]──────────────┐
│ If you wish to start a new page for each ENDITEM on the Travelers, │
│ then select Y (YES). │
│ The default NOT to skip page. │
│ │
│ Skip Page Between ENDITEMS? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 72
■ TRAVELER SETUP & DEFINITION
Use this Configuration Option to define the 2 Traveler types.
Travelers can contain as many fields that can print across your printer.
╔═══════════════════════[ TRAVELER SETUP & DEFINITION ]══════════════════════╗
║ DAYO MRP has 2 styles of Travelers for each type (STANDARD and LASER). ║
║ You define what fields are printed onto each. ║
║ The number of fields is limited by the width of your paper, ie: ║
║ Standard Traveler: Page Size 10 CPI 17.1 CPI ║
║ 8.5x11 78 Width 130 Width ║
║ 14 7/8x11 130 Width 190 Width ║
║ Laser Traveler: 11/8.5 10 CPI ║
║ 130 Width ║
║ ║
║ ║
║ Select Option -> Setup & Define Traveler Type 1 ║
║ Setup & Define Traveler Type 2 ║
║ Exit ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
■ TRAVELER STYLE/TYPE
You can define 2 Traveler (what gets printed onto them...)
╔═════════════[ TRAVELER SETUP & DEFINITION - TRAVELER STYLE #1 ]════════════╗
║ Current Width: 72 ║
║ Title Field Len Select ║
║ Select Option -> Item ITEM 12 Yes ║
║ VendorItem VENDITEM 12 No ║
║ Description DESC 30 No ║
║ LOC LOCATION 3 No ║
║ Weight WEIGHT 8 No ║
║ QTY QTY 10 No ║
║ UOM UNIT 3 No ║
║ PakQty PACKQTY 6 No ║
║ UnitQty UNITQTY 7 No ║
║ Labor LABOR 10 No ║
║ Labor1 LABOR1 10 No ║
║ Labor2 LABOR2 10 No ║
║ Hours HOURS 10 No ║
║ Cost COST 10 No ║
║ Onhand ONHAND 10 No ║
║ Vendor VENDOR 10 No ║
║ PER QTY PER_QTY 10 Yes ║
║ Required REQ_QTY 10 Yes ║
║ Finished FINIS_QTY 10 No ║
╚════════════════════════════════════════════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 73
■ TRAVELER FIELDS
The following fields are available to print on Travelers:
Item ITEM 12 Yes
VendorItem VENDITEM 12 No
Description DESC 30 No
LOC LOCATION 3 No
Weight WEIGHT 8 No
QTY QTY 10 No
UOM UNIT 3 No
PakQty PACKQTY 6 No
UnitQty UNITQTY 7 No
Labor LABOR 10 No
Labor1 LABOR1 10 No
Labor2 LABOR2 10 No
Hours HOURS 10 No
Cost COST 10 No
Onhand ONHAND 10 No
Vendor VENDOR 10 No
PER QTY PER_QTY 10 Yes
Required REQ_QTY 10 Yes
Finished FINIS_QTY 10 No
WIP QTY WIP_QTY 10 Yes
LastTime LASTTIME 8 No
LastDate LASTDATE 8 No
LaborXPER LABOR*PER 10 Yes
Labor1XPER LABOR1*PER 10 No
Labor2XPER LABOR2*PER 10 No
HoursXPER HOURS*PER 10 No
CostXPER COST*PER 10 No
LaborXREQ LABOR*REQ 10 No
Labor1XREQ LABOR1*REQ 10 No
Labor2XREQ LABOR2*REQ 10 No
HoursXREQ HOURS*REQ 10 Yes
CostXREQ COST*REQ 10 No
LaborXWIP LABOR*WIP 10 No
Labor1XWIP LABOR1*WIP 10 No
Labor2XWIP LABOR2*WIP 10 No
HoursXWIP HOURS*WIP 10 No
CostXWIP COST*WIP 10 Yes
Defined1 BLANK 8 No
Defined2 BLANK 8 No
Defined3 BLANK 8 No
Defined4 BLANK 8 No
Defined5 BLANK 8 No
Defined6 BLANK 8 No
Defined7 BLANK 8 No
Defined8 BLANK 8 No
Defined9 BLANK 8 No
DefinedA BLANK 8 No
DefinedB BLANK 8 No
DefinedC BLANK 8 No
DefinedD BLANK 8 No
DefinedE BLANK 8 No
DefinedF BLANK 8 No
POS Position 7 No
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 74
■ DEFINED FIELDS
Defined fields print blank spaces with a title of your choice onto the
travelers, as in the following Traveler report extract/example:
TRAVELER YOUR COMPANY, INC Page 1
Type 1 Date: 01/19/91 Time 20:16:28
Item PER QTY Required WIP QTY Dept #1 Dept #2 Dept #3
------------ ---------- ---------- ---------- -------- -------- --------
A24234 0.00 110.00 0.00 ________ ________ ________
APSBH-2 1.00 110.00 0.00 ________ ________ ________
APSBH-1 2.00 220.00 0.00 ________ ________ ________
■ AUTOMATIC GL POSTING
This Configuration routine was added to allow you to post your
transactions (ie: Invoice Posting, Cash Receipts, and Credit Memos),
automatically into General Ledger (GL). If this option is set to 'Y' (Yes),
each time you adjust or edit key accounting fields (ie: COST, AMOUNT,
SUBTOTAL, FREIGHT, ADJUST, QTY...), a GL transaction records will be created.
This routine includes an option to browse, edit, add, and/or delete
records in the General Ledger Class Code Table/Database (GLCLASS.DBF).
╔══════════════════════════[ AUTOMATIC GL POSTING ]══════════════════════════╗
║ If you are using General Ledger (GL), you can automatically update ║
║ or create GL transactions every time you make an accounting adjustment. ║
║ ║
║ Do you want Automatic GL Posting? (Y/N) ║
║ ║
║ Default CLASS Code: AR Name: RECEIPTS ║
║ Debit Account: 10000-000000 Credit Account: 20000-000000 ║
║ Database: RECEIPTS.DBF Field: AMOUNT ║
╟─────────────[ SELECT DEFAULT ACCOUNTS RECEIVABLE CLASS CODE ]──────────────╢
║ CLASS NAME DEBIT CREDIT ║
║──────────╥────────────────────────────────╥──────────────╥─────────────────║
║ AR ║ Invoice Freight *** ║ 10000-000000 ║ 40000-000000 ║
║ AR ║ 1st Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║
║ AR ║ 2nd Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║
║ AR ║ Invoice Adjustments *** ║ 10000-000000 ║ 40000-000000 ║
║ AR ║ Invoice Paid/Collected *** ║ 10000-000000 ║ 40000-000000 ║
║ REC ║ RECIPTS INTO INVENTORY ║ 91000-000000 ║ 20000-000000 ║
║ INV ║ RECEIPTS INTO THE INVENTORY ║ 91000-000000 ║ 11000-000000 ║
║ MRP ║ MRP/WIP ║ 10000-000000 ║ 20000-000000 ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete)
Find: F5 (CLASS) F6 (DEBIT) F7 (CREDIT) F8 (NAME) F9 (DATABASE)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 75
■ EDIT CLASS CODE RECORD
Press 'F2' to edit a Class Code record. Note, valid entries are crucial
to making this posting process work correctly...
╔═════════════════════════[ EDIT CLASS CODE RECORD ]═════════════════════════╗
║ CLASS Code: MRP ║
║ Name: MRP/WIP ║
║ Debit Account: 11000-000000 ║
║ Credit Account: 10000-000000 ║
║ Database (.DBF): INVADJ.DBF ║
║ Field: COST*QTY ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit)
■ ADD NEW CLASS CODE RECORD
Press 'Ctrl N' to add a new CLASS code record.
╔═══════════════════════[ ADD NEW CLASS CODE RECORD ]════════════════════════╗
║ CLASS Code: ║
║ Name: ║
║ Debit Account: 00000-000000 ║
║ Credit Account: 00000-000000 ║
║ Database (.DBF): INVADJ.DBF ║
║ Field: ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════════════════════════════════════════════════════════════════════╝
Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit)
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 76
■ FIND CLASS CODE
Use the 'F5' through 'F9' keys to locate a desired CLASS code record
Press 'F5' to locate a CLASS code record based on the CLASS field, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter CLASS+DATABASE: │
└───────────────────────────────────────────────────TJS LAB───┘
Press 'F6' to locate a CLASS code record based on the DEBIT field, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter DEBIT: 30000-200000 │
└───────────────────────────────────────────────────TJS LAB───┘
Press 'F7' to locate a CLASS code record based on the CREDIT field, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter CREDIT: 10000-200000 │
└───────────────────────────────────────────────────TJS LAB───┘
Press 'F8' to locate a CLASS code record based on the NAME field, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter NAME: │
└───────────────────────────────────────────────────TJS LAB───┘
Press 'F9' to locate a CLASS code record based on the DATABASE field, ie:
┌─────────────────────────────────────────────────────────────┐
│ Enter DATABASE: │
└───────────────────────────────────────────────────TJS LAB───┘
■ COLOR MONITOR
┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐
│ The default is color, high intensity │
│ │
│ Do you have a color monitor? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
■ COLOR INTENSITY
┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐
│ Intensity is only applicable with color set to Y. │
│ It will make your colors brighter... │
│ │
│ Set Color Intensity On? (Y/N) │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 77
■ MISCELLANEOUS ROUTINES
- The MISC routines is a collection of 17 very useful Database Management
Routines. These routines provide you with the 'ability to do whatever was
left out of the rest of the program...'. These routines were modeled after
dBase (tm) III+/IV functions. Familiarity with dBase will help with the
understanding and execution of these routines.
█ █ ▄██▄ ███ █ █ ▀█▀ █████ █ █ ▄███ ▄█▄ █ █ █████ ▀█▀ ▄██▄ █ █ █
█ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ █ ██ █ █
█ █ ▀██▄ ██ █ █ █ █ █ ████ █ █▄█ █ █ █ █ █ █ ████ █
█ █ █ █ ▀█ █ █▀ █ █ █ █ █ █▀ ▀█ █ █ █ █ █ █ █ ██ █
▀██▀ ▀██▀ ███ ▀█▀█▀ ▄█▄ █ █ █ ▀███ █ █ ▀██▀ █ ▄█▄ ▀██▀ █ █ ▄
USE WITH CAUTION!
YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES
YOU CAN ALSO PERMANENTLY MESS THINGS UP!
■ MISC ROUTINES MENU:
DAYO MRP Version 3.0 TJS LAB ┌──[February 1991]───┐
╔════════════════════╗▀█ │S M T W T F S │
║ MISC ROUTINES ║ █ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤
╟────────────────────╢─█ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5│
║ APPEND FROM ║ █ █░ █░ █░█░ ▀█░██░ █░ █░ │ 6 7 8 9 10 11 12│
║ BROWSE DATABASES ║─█ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │13 14 15 16 17 18 19│
║ COPY (.DBF) TO ║ █ █░ █░ █░ █░ █░ █░ █░ │20 21 22 23 24 25 26│
║ CREATE DATABASE ║─█ █▀██▀ █░ █░ █░ ▀███▀ │27 28 29 30 31 │
║ DELETE RECORDS ║ █ │ │
║ ERASE FILE ║─█ └────────────────────┘
║ EXIT TO DOS ║ █
║ INDEX A DATABASE ║─█ ███▄ ▄███░
║ LIST FIELDS ║ █ █████░ █████░ ███▄███████░
║ PACK DATABASE ║██ ██████░ ██████░ ███░ ███░ ███▄███████░
║ MODIFY DATABASE ║█ ███░██████░███░ ███░ ███░ ███░ ███░
║ RECALL RECORDS ║ ███░ ████░ ███░ ███░ ███░ ███░ ███░
║ RETURN TO MENU ║ ███░ ██░ ███░ ███████████░ ███░ ███░
║ RUN (DOS COMMAND) ║ ███░ ██░ ███░ ███▀████░ ███▀███████░
║ SIMPLE EDITOR ║▄▄▄▄▄▄▄▄▄▄ ███░ ▀▀ ███░ ███░ ▀███░ ███░
║ SORT DATABASE ║ Size█ ███░ ███░ ███░ ▀███░ ███░
║ TYPE (PRINT) FILE ║ 341148█ Materials ███░ ▀███░ ███░
║ ZAP DATABASE ║ 439272█ Requirement ███░
╟────────────────────╢ 3318931█ Planning
║ Select Option ║▀▀▀▀▀▀▀▀▀▀
╚════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 78
■ APPEND FROM
- Used to copy records from one database into another database, or to create
records from ASCII files (SDF or DELIMITED).
- The Initial Screen will prompt you to enter the file name of the database
you are to append/copy the data into. At this point, you can either type in
the name of the target database, or ...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
└────────────────────────────────────────────────────────────────────────────┘
- If it exists in the current directory, press enter on an empty prompt to
display all databases to select from.
┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │INVENT.DBF │ 375 │ 09/16/89 │ │
│ │AR.DBF │ 7219 │ 09/16/89 │ │
│ │HISTORY.DBF │ 103 │ 09/16/89 │ │
│ │PERSONS.DBF │ 24271 │ 09/16/89 │ │
│ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
│ │
└───────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of Append:
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
└──────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 79
- If you are appending from another database (.DBF) then select 'Standard'.
- Select the SDF option if you are appending from a 'flat' ASCII file.
- Select the DELIMITED option if you are appending from a delimited ASCII
file. Delimited files contain records in which the fields are separated by
commas, and its character fields contained in double quotes...
- If you select a Standard Append, you will then be prompted to enter the name
of the database you wish to get the data from. If you selected the SDF or
DELIMITED options, then enter the file name containing the data to be
appended into your target database.
┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into PERSONS.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: PERSON1.TXT │
│ │
│ │
└──────────────────────────────────────────────────────────────────────────┘
- The number of records appended into the target database will be displayed
upon completion of the task...
┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐
│ │
│ Enter Database Name To Append Data Into: │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ Append Data Into INVENT.DBF From INVENTY.DBF │
│ │
│ Type of Append: Standard SDF DELIMITED │
│ │
│ Enter Database Name To Append Data FROM: INVENT.DBF │
│ │
│ │
│ │
│ There Were 1 Records Appended Into INVENT.DBF │
│ │
│ │
│ │
│ Press Any Key To Continue... │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 80
■ BROWSE DATABASES
- Used to edit/view records in a database. Enter the database name you wish to
edit/browse, or if it exists in the current directory, press enter on an
empty prompt to bring up a window box to select from.
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: INVENT.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- If there exists an index (.NDX or .NTX), with the same name as the database,
it will be utilized... The DAYO Inventory indexes are the exception. They
are automatically set/used.
- An example of a browse screen:
TJS LAB, PO BOX 585366
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ MFG_PART DESC PRICE LIST │
│──────────────────╥────────────────────────────────╥────────────╥───────────│
│ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │
│ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │
│ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │
│ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │
│ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │
│ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │
│ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │
│ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │
│ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │
│ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │
│ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │
│ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │
│ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │
│ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │
│ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │
│ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │
│ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │
├──────────────────╨────────────────────────────────╨────────────╨───────────┤
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
51/60
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 81
- To edit a memo field, just highlight the field, and start typing.
* * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING!
┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐
│ PRICE LIST YOURPART NOTES │
│───────────────────────╥────────────╥─────────────────╥─────────────────────│
│ 896.16 ║ 1792.32 ║ ║ <Memo> │
│ 1064.19 ║ 2128.38 ║ ║ <Memo> │
│ 672.12 ║ 1344.24 ║ ║ <Memo> │
│ 1736.31 ║ 3472.62 ║ ║ <Memo> │
│ 504.09 ║ 1008.18 ║ ║ <Memo> │
│ 784.14 ║ 1568.28 ║ ║ <Memo> │
│ 1400.25 ║ 2800.50 ║ ║ <Memo> │
┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐
│You can edit memo fields too... │
│ │
│ │
│ │
│ │
│ │
│ │
└───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘
│ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │
└────────────────────────────────────────────────────────────────────────────┘
- Special keys for 'moving around' the BROWSE screen are:
Left Arrow Key - Move to next field to your left
Right Arrow Key - Move to next field to your right
Ctrl Home - Go to the leftmost field
Ctrl End - Go to the rightmost field (on the end of the record)
Up Arrow - Move highlight to the previous record
Down Arrow - Move highlight to the next record
PgUp - Page up a full screen of records
PgDn - Page down a full screen of records
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end or last record of the file
Ctrl N - Add a record (where applicable)
Ctrl U - Delete a record (where applicable)
F5 - To seek/find a record based upon the active index
Esc - Exit the current operation
- Remember that there are many more fields to the right of the screen. Press
the right arrow key to view them...
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 82
■ COPY (.DBF) TO
- Copy records to another (new) database. Use this option to copy select
records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can
also be used to create backups of data (EG: copy to floppy).
┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: │
│ Enter┌────────[ PICK A DATABASE ]───────────┐y... │
│ │ FILE NAME SIZE DATE USED│ │
│ ├──────────────┬────────────┬──────────┤ │
│ │HARPS.DBF │ 375 │ 09/16/89 │ │
│ │INVENT.DBF │ 7335 │ 09/16/89 │ │
│ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │
│ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │
│ │AP.DBF │ 289 │ 09/16/89 │ │
│ └──────────────┴────────────┴──────────┘ │
│ ┌───────────────────────┐│
│ │ Highlight a database ││
│ │ using the ││
│ │ arrow keys, then press││
│ │ Enter/Return. ││
│ └───────────────────────┘│
└────────────────────────────────────────────────────────────────────────────┘
- The next prompt will be to select the type of COPY TO option you want:
┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐
│ │
│ Enter Database Name To COPY FROM: INVENT.DBF │
│ Enter Nothing For Listing Of Current Directory... │
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ │
│ Copy Records From INVENT.DBF │
└────────────────────────────────────────────────────────────────────────────┘
- The Standard option is simply creating another database (.DBF). The SDF and
DELIMITED options will create ASCII files. The STRUCTURE option creates a
new database with the same file structure as the initial database (no
records copied).
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 83
- The next prompt (optional), requires some knowledge of dBase (tm). This
prompt is requesting the user to enter a condition or filter. If all
records are to be copied, just press Enter on an empty prompt.
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW.DBF │
│ │
│ Enter Condition: │
│ Sample condition: COST > 100 │
│ │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
- This 'Condition' option is useful for coping only specific records into a
new location. Any valid dBase/Clipper statement (as shown next) is
fine...
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW DBF │
│ │
│ Enter Condition: PRICE>0 │
│ Sample condition: COST > 100 │
│ │
│ Copy Records From NEW │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 84
- The following window message will appear while the COPY TO routine does
its task:
┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐
│║ ║│
│║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│
│║NOTES{M} ■ ║│
│╚══════════════════════════════════════════════════════════════════════════╝│
│ │
│ Type of Copy To: Standard SDF DELIMITED STRUCTURE │
│ │
│ Enter SDF File Name To Copy Data TO: NEW10 │
│ │
│ Enter Condition: PRICE>0 │
│ Sample cond┌───────────────────────────────────────────────┐ │
│ │┌─────────────────────────────────────────────┐│ │
│ CONDITION: ││┌───────────────────────────────────────────┐││ │
│ │││┌─────────────────────────────────────────┐│││ │
│ ││││Hold those camels while I do this COPY TO││││ │
│ │││└─────────────────────────────────────────┘│││ │
│ ││└───────────────────────────────────────────┘││ │
│ │└─────────────────────────────────────────────┘│ │
│ └───────────────────────────────────────────────┘ │
│ Copy Records From SDF To NEW10 │
└────────────────────────────────────────────────────────────────────────────┘
■ CREATE DATABASE
- Create a new database. This routine lets you create entirely new database
structures. At the FIELD_NAME field, enter a unique field name. At the
FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date,
'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the
size/length of the character and/or numeric field. At the FIELD_DEC field,
enter the number of decimals for the numeric field.
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ ║ ║ 0 ║ 0 │
│ ║ ║ ║ │
│ ║ ║ ║ │
┌─────────────│ ║ ║ ║ │────────────┐
│ │ ║ ║ ║ │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 85
* * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * *
IT IS SLIGHTLY BOTHERSOME
SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING...
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to edit the new database.
This error may even cause your computer to hang!
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐
│ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │
│────────────╥────────────╥───────────╥───────────│
│ NAME ║ C ║ 30 ║ 0 │
│ AGE ║ N ║ 5 ║ 1 │
│ DEAD ║ L ║ 1 ║ 0 │
│ BIRTHDATE ║ D ║ 8 ║ 0 │
┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐
│ │ ║ ║ 0 ║ 0 │ │
│ ENTER TH│ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
│ │ ║ ║ ║ │ │
└─────────────│ ║ ║ ║ │────────────┘
│ ║ ║ ║ │
│────────────╨────────────╨───────────╨───────────│
│ Press Enter to edit any field... │
└──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 86
■ DELETE RECORDS
- Delete selected records from databases. The first prompt is for the name of
the database you wish to mark records for deletion. Like many of the other
routines, you can press enter on an empty prompt to bring up all databases
that exist in the current directory:
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│D.DBF │ 259 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/16/89 │
│XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└────────────────────────────────────────────────────────────────────────────┘
- After selecting the database, all its fields will be presented atop the
screen so as to aid the user in entering a condition/filter. The use of the
condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax
is required. Note the use of the Clipper Function: EMPTY().
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐
│ Enter Database Name: TRASH │
│ Delete Records For Condition: EMPTY(PART) │
│ Sample condition: COST > 100 │
│ CONDITION: EMPTY(PART) │
│ Number of Records Deleted: 208 │
│ Press any key to continue... │
└────────────────────────────────────────────────────────────────────────────┘
- The number of records deleted will be displayed upon the screen as depicted
just above...
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 87
■ ERASE FILE
- Erase a file (forever!). Use this option with extreme care!
Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY
REMOVED FROM EXISTENCE
NO SECOND CHANCES HERE...
- The first prompt is for the file name. You can press enter on an empty
prompt to bring up a window selection of all files in the current directory.
┌────────────────────────┐
┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘
│BKDOOR.DOC │ 37029 │ 09/17/89 │
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│D.DBF │ 259 │ 09/16/89 │
│D.DBT │ 512 │ 09/16/89 │
│DAYOBK.BAK │ 36879 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
│DAYOBK.OBJ │ 35585 │ 09/16/89 │
│DAYOCAL.MAP │ 35 │ 09/16/89 │
│DDD.DBF │ 375 │ 09/16/89 │
│DDD.DBT │ 512 │ 09/16/89 │
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- To ERASE a file, just highlight it, then press Enter...
■ EXIT TO DOS
- This option will close all open files and databases and exit to DOS without
having to return to the main menu exit routine.
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 88
■ INDEX A DATABASE
- You will be prompted to select the database you wish to index. After
selecting the database, by typing in the name or pressing Enter on an empty
prompt (then selecting from the window), you will be given a listing of all
fields in that database atop the screen.
┌────────[ PICK A DATABASE ]───────────┐.
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DAD.DBF │ 259 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SPW.DBF │ 7335 │ 09/16/89 │
│SOW.DBF │ 103 │ 09/16/89 │
│BOY.DBF │ 24387 │ 09/17/89 │
│SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
- You will now be prompted to enter the name of the Index File. It will be
(by default), named exactly the same as the selected database, with the
exception of the extension. This will default to .NDX or .NTX depending on
whether you linked NDX.OBJ with your application.
*** Remember that the BROWSE routine only looks at indexes with the same
name as the database.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
└───────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 89
- At the prompt for the index key, enter a field name, or a valid
dBase/Clipper expression.
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ INDEX A DATABASE ]────────────────────────┐
│ Enter Name of Index File: TRASH.NTX │
│ Enter the Key Expression: PART+MFG_PART │
└───────────────────────────────────────────────────────────────┘
■ LIST FIELDS
- List fields to screen or printer. This routine is a great tool for providing
simple reports and lists. The first prompt will be for the database you wish
to work with. Type the name of the file, or press Enter on an empty prompt
to bring up a window of all databases in the current directory for
selection.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│INVEND.DBF │ 259 │ 09/16/89 │
│INVENT.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SOMEDAY.DBF │ 7335 │ 09/16/89 │
│TANGO.DBF │ 103 │ 09/16/89 │
│AP.DBF │ 24387 │ 09/17/89 │
│BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
└───────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 90
- The next prompt is for a condition or filter. This makes it possible to list
only specific records that meet that condition you enter. The condition must
be a valid dBase/Clipper expression, or none (to list all).
╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌─────────────────────────────────────────────────────┐
│ Enter Filter: │
│ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
└─────────────────────────────────────────────────────┘
┌───────────────────────────────────────────────────────────────┐
│ Enter Database Name: │
│ │
└───────────────────────────────────────────────────────────────┘
- A window box appears next displaying all the fields in the selected database
and an option to list all fields. Highlight any combination of fields ( or
ALL) that you want listed.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║ ├─────────────────┤ ║
╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝
│RECNO() │
│MFG_PART │
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 91
- The fields you select will be displayed at center top of screen. Press Esc
to exit the "PICK THE FIELDS YOU WANT LISTED" window.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│PRICE │
│YOURPART │ ┌────────────────────────────────────────────────────┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
- At the next prompt, you can send the list to the SCREEN, PRINTER OR
FILE.
╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ │ PICK THE FIELDS │ ║
╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║
║N├─────────────────┤ │PART │ ║
╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝
│RECNO() │ │PRICE │
│PART │ └────────────────────┘
│DESC┌──────────────────────────────────────────────────────────────────┐
│PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │
│LIST│ │
│YOUR└──────────────────────────────────────────────────────────────────┘─┐
│NOTES │ │ Enter Filter: │
├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │
│PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘
└─────────────────┘────────────────────────────────────────────────────┐
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 92
- The list is very simple, and if displayed onto the screen, may look like the
following:
PART MFG_PART PRICE
4523 0.00
DAYO9S 41926 1904.34
DAYO10S 13564 616.11
DAYOCOMP 45625 2072.37
DAYOALLS 43159 1960.35
INDEXER 50558 2296.41
INDEXERS 51791 2352.42
5 DEMO 4932 224.04
DAYO13S 20963 952.17
MENUS 53024 2408.43
OFFSITEP 56724 2576.46
ONSITEP 57957 2632.47
DAYO2S 24662 1120.20
DAYO9 40693 1848.33
DAYO10 12331 560.10
DAYOCAL$ 44392 2016.36
DAYO13 19730 896.16
DAYO2 23429 1064.19
DAYO11 14797 672.12
DAYO8 38227 1736.31
DAYO1 11098 504.09
DAYO12 17264 784.14
DAYO5 30828 1400.25
......PRESS ANY KEY TO CONTINUE......
■ MODIFY DATABASE
- Change the fields/structure of a database. You can add new fields, delete
fields, change the length and type of field in any of the databases. At the
FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter
a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M'
for memofield. At the FIELD_LEN field, enter the size/length of the
character and/or numeric field. At the FIELD_DEC field, enter the number of
decimals for the numeric field.
********************************************************
*** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST ***
*** IT IS SLIGHTLY BOTHERSOME SORRY! ***
********************************************************
*** If any error is made in this routine, you will experience an
error, either immediately, or when you start to access the database.
This error may even cause your computer to hang!
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 93
*** Be sure to Press: Ctrl W when you are finished and
satisfied. Pressing Esc will just negate your efforts..
■ PACK DATABASE
- Pack a database (removed deleted records). This option will permanently
remove any records marked for deletion. This is another routine you should
use with great care! As in many of the other of the routines, you will be
prompted to enter the name of the database you wish to pack. Enter the name
or press Enter on an empty prompt to view the window.
┌─────┐
│PACK!│
└─────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│GOODDATA.DBF │ 259 │ 09/16/89 │
│HAP.DBF │ 375 │ 09/16/89 │
│NEW.DBF │ 195 │ 09/17/89 │
│SDF.DBF │ 7335 │ 09/16/89 │
│LOIN.DBF │ 103 │ 09/16/89 │
│TRASH.DBF │ 24387 │ 09/17/89 │
│FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌──────────────────────────────────────────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- After selecting the database, you will be prompted to respond with a Yes or
No (to Pack or not to Pack...). This is the last chance you have to change
your mind...
┌──────────────────────────────────────────────────────────────────────────┐
│ PACK TOM3 │
│ Are you sure you want to PACK (remove deleted records) ? N │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 94
■ RECALL RECORDS
- Recalls records previously marked for deletion. This option is identical to
the DELETE RECORDS option discussed earlier...
■ RETURN TO MENU
- Returns to the procedure that called MISC Routines.
■ RUN (DOS COMMAND)
- Run a DOS command (EG: dir/w). This option is helpful in that it allows
you to run programs at the DOS level (within memory constraints).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN CD\DOS │
└───────────────────────────────────────────────────────────────────────────┘
- One useful option is to type and Enter: COMMAND at this prompt. You will be
running another DOS Shell totally out of the program (it still is in memory
though).
┌───────────────────────────────────────────────────────────────────────────┐
│ RUN COMMAND │
└───────────────────────────────────────────────────────────────────────────┘
- Press and Enter: EXIT to return to your Clipper Application.
EG:
The COMPAQ Personal Computer MS-DOS
Version 3.31
(C) Copyright Compaq Computer Corp. 1982, 1987
(C) Copyright Microsoft Corp. 1981, 1987
C:\KISBBS>EXIT
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 95
■ SIMPLE EDITOR
- A simple editor and word processor. Use this option to create and read
simple TEXT files. File size is limited to your machines capabilities or
32,000k. The first prompt is for the name of the file you wish to edit. Type
in the name, or press Enter on an empty prompt to bring up a window option
box containing all files in the current directory.
┌────────────────────────┐
┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │
│ FILE NAME SIZE DATE USED│ │ using the │
├──────────────┬────────────┬──────────┤ │ arrow keys, then press │
│B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │
│BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘
│BKDOOR.ZIP │ 19415 │ 09/16/89 │
│DAYOBK.LIB │ 36879 │ 09/16/89 │
│DAYOBK.LST │ 2056 │ 09/16/89 │
┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐
│ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │
│ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │
└────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘
│DDD.NTX │ 2048 │ 09/16/89 │
│DEMO.EXE │ 245404 │ 09/16/89 │
│DEMO.MAP │ 7780 │ 09/16/89 │
└──────────────┴────────────┴──────────┘ More
- *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...),
so be careful at what you select for viewing/editing.
- If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those
changes. If you exit with an Esc, all changes will be lost!
┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐
│CLIPPER demo │
│CLIPPER MISC │
│KWAIT 10 │
│LIB MISC-+MISC,MISC.LST,MISC │
│KWAIT 10 │
│TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │
│KWAIT 10 │
│DEMO │
└────────────────────────────────────────────────────────────────────────────┘
Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 96
- Special keys for 'moving around' the SIMPLE EDITOR screen are:
Left Arrow Key - Move to your left
Right Arrow Key - Move to your right
Ctrl Home - Go to the top, leftmost corner of window
Ctrl End - Go to the bottom, rightmost corner of window
Up Arrow - Move up one line
Down Arrow - Move down one line
PgUp - Page up a full screen
PgDn - Page down a full screen
Ctrl PgUp - Go to the beginning of the file
Ctrl PgDn - Go to the end of the file
* F2 - Import text from a text file
* Ctrl W - Save Changes and Exit
* Esc - ABORT Changes and Exit
The margin may exceed the boundaries on the right side of the screen, but
the text is easily accessed using the special keys above...
■ SORT DATABASE
- This option takes a database, sorts it, and copies the result into a new
database. The first prompt is for the name of the database you want to sort.
Enter the name, or press Enter on an empty prompt to bring up a window box
containing all databases in the current directory.
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DOG.DBF │ 259 │ 09/16/89 │
│CAT.DBF │ 375 │ 09/16/89 │
│CAR.DBF │ 195 │ 09/17/89 │
│BAM.DBF │ 7335 │ 09/16/89 │
│HARP.DBF │ 103 │ 09/17/89 │
│TRAIN.DBF │ 24387 │ 09/17/89 │
│HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐
└──────────────┴────────────┴──────────┘ │ Highlight a database │
│ using the │
┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
│ └────────────────────────┘
│ │
└───────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 97
- The next prompt is for the name of the database you will be creating with
the sorted data.
╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗
│║ ║
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚═══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: INVNET.DBF │
│ Enter Name of Sorted File: INVNET1.DBF │
│ │
└───────────────────────────────────────────────────────────────┘
- The next prompt is for the sort field (limited to 1 field)...
╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗
╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║
║NOTES{M} ■ ║
╚══════════════════════════════════════════════════════════════════════════╝
┌───────────────────[ SORT A DATABASE ]─────────────────────────┐
│ Enter Database Name: TOM.DBF │
│ Enter Name of Sorted File: TOM1.DBF │
│ Enter the Key Expression: PART │
└───────────────────────────────────────────────────────────────┘
■ TYPE (PRINT) FILE
- Prints an ASCII/text file to screen or printer. The first prompt is for the
file name.
┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐
│ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │
│ Press Enter/Return on an empty field to get a current directory listing. │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 98
- The display of the file (any type), is continuous, but can be paused by
any key (except the Enter & Esc keys). Pressing the Enter key will slow the
printing of the file onto the screen. Press Esc to Abort the display... A
sample display:
FUNCKEY...........MISC FUNIQUE...........MISC
FZAP..............MISC GET_PIC1..........MISC
ISDATA............MISC ISDBF.............MISC
MENU_KEY..........MISC MISC..............MISC
OKFILE............MISC PACKIT............MISC
PICKDBF...........MISC PROCLIST..........MISC
SHOW_INS2.........MISC STATLINE2.........MISC
TOG_INS2..........MISC XKEY_CLEAR........MISC
XKEY_NORM.........MISC XMEMO.............MISC
MISC
BKDOOR BROWSEIT CENTER1 COLORSET
DBFUNCT DBFUNCT6 EDITOR FACHOICE
FAPPEND FCOPY2 FDBF1 FDELETE
FERASE FILESZ FILE_UDF FILT
FINDER FINDEX FMAKEDB FMODYDB
FNEW FRECALL FRUN FSCROLL1
FSORT FTYPEIT FUNCKEY FUNIQUE
FZAP GET_PIC1 ISDATA ISDBF
MENU_KEY MISC OKFILE PACKIT
PICKDBF PROCLIST SHOW_INS2 STATLINE2
TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO
PRESS ANY KEY TO CONTINUE...
■ ZAP DATABASE
- Totally erase all records in database (forever!). When you
want to remove every record from a database, then use this option. Use with
EXTREME CAUTION! The first prompt is for the file name. Enter the name of
the database you are to 'clean out', or press Enter to select the database
from a window containing all databases in the current directory.
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 99
┌────┐
│ZAP!│
└────┘
┌────────[ PICK A DATABASE ]───────────┐
│ FILE NAME SIZE DATE USED│
├──────────────┬────────────┬──────────┤
│DENVER.DBF │ 259 │ 09/16/89 │
│OHIO.DBF │ 375 │ 09/16/89 │
│NEWYORK.DBF │ 195 │ 09/17/89 │
│MONTANA.DBF │ 7335 │ 09/16/89 │
│SC.DBF │ 259 │ 09/17/89 │
│EARS.DBF │ 103 │ 09/17/89 │
│FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐
│MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │
│CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │
└──────────────┴────────────┴──────────┘───│ arrow keys, then press │
│ Enter Database Name: │ Enter/Return. │
└──────────────────────────────────────────└────────────────────────┘
- You will be prompted one last time as to whether you still want to ZAP the
selected database. Press Y for Yes, N for No...
┌────┐
│ZAP!│
└────┘
┌──────────────────────────────────────────────────────────────────────────┐
│ ZAP TRASH │
│ Are you sure you want to ZAP (remove all records permanently) ? N │
│ │
└──────────────────────────────────────────────────────────────────────────┘
│ Enter Database Name: │
└───────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 100
■ HELP SCREENS
- While in the browse screens, some of the option windows, and in the SIMPLE
EDITOR, pressing the F1 key, will display a help screen.
- BROWSE help:
┌──────────────────────[ DAYOMRP HELP: DBEDIT, 0, ]──────────────────────────┐
│ │
│- Special keys for 'moving around' the BROWSE screen are: │
│ │
│ Left Arrow Key - Move to next field to your left │
│ Right Arrow Key - Move to next field to your right │
│ Ctrl Home - Go to the leftmost field │
│ Ctrl End - Go to the rightmost field (on the end of the record)│
│ Up Arrow - Move highlight to the previous record │
│ Down Arrow - Move highlight to the next record │
│ PgUp - Page up a full screen of records │
│ PgDn - Page down a full screen of records │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end or last record of the file │
│ Ctrl N - Add a record (where applicable) │
│ Ctrl U - Delete a record (where applicable) │
│ F5,F6,F7 - To seek/find a record based upon the active index │
│ Esc - Exit the current operation │
│ │
│ Remember that there are many more fields to the right of the screen. │
│ Press the right arrow key to view them... │
└────────────────────────────────────────────────────────────────────────────┘
- Option Box Help:
┌────────────────────────[ DAYOMRP HELP: ACHOICE, 0, ]───────────────────────┐
│ │
│ │
│ │
│ │
│ - Special keys for 'moving around' the Option Box are: │
│ │
│ Up Arrow - Move up one option │
│ Down Arrow - Move down one option │
│ PgUp - Page up multiple records │
│ PgDn - Page down multiple records │
│ Esc - ABORT and Exit │
│ │
│ │
│ After highlighting the option you desire, press Enter... │
│ │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 101
- Editor help:
┌───────────────────────[ DAYOMRP HELP: MEMOEDIT, 0, ]───────────────────────┐
│ │
│ - Special keys for 'moving around' the EDITOR screen are: │
│ │
│ Left Arrow Key - Move to your left │
│ Right Arrow Key - Move to your right │
│ Ctrl Home - Go to the top, leftmost corner of window │
│ Ctrl End - Go to the bottom, rightmost corner of window │
│ Up Arrow - Move up one line │
│ Down Arrow - Move down one line │
│ PgUp - Page up a full screen │
│ PgDn - Page down a full screen │
│ Ctrl PgUp - Go to the beginning of the file │
│ Ctrl PgDn - Go to the end of the file │
│ Ctrl W - SAVE Changes and Exit │
│ Esc - ABORT Changes and Exit │
│ F2 - Import another text file into your document │
│ │
│ The margin may exceed the boundaries on the right side of the screen, │
│ but the text is easily accessed using the special keys above... │
│ │
│ │
└────────────────────────────────────────────────────────────────────────────┘
■ EXPANDED HELP
After Version 1.3, expanded help routines were added to all DAYO modules.
At almost all prompts and menus you can press F1 for help. Help can be a
function key message as displayed on previous page, a message that you have
created (user defined & inputted), or the ability to read the documentation
on the screen (saves paper).
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 102
■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES
If you press F1 and no user defined & inputted message exists for that
section of the program you are currently in you will receive a message to
this effect, and then a blank/empty screen.
The editing keys for this option are the same as for the Simple Editor
(previous page).
DAYO MRP Version 3.0 TJS LAB ┌──[February 1991]───┐
┌──────[ DAYO HELP Called by Program: DAYOMRP Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ │
│ │
│ ╔════════════════════════════════════════════════════════╗ │
│ ║ No Online Help Messages Exist for this prompt... ║ │
│ ║ ║ │
│ ║ You can type in any help message you wish, or ║ │
│ ║ press F1 to view the document for DAYOMRP. ║ │
│ ║ ║ │
│ ║ ║ │
│ ║ Press any key to continue... ║ │
│ ╚════════════════════════════════════════════════════════╝ │
│ │
│ │
├───────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │
└───────────────────────────────────────────────────────────────────────────┘
If you wish to input anything at this point, just type whatever you
wish, remembering to press Ctrl W to save all changes. Pressing Esc will
not save ANY changes ( all effort you put into writing a help message will
be lost! ).
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 103
DAYO MRP Version 3.0 TJS LAB ┌──[February 1991]───┐
┌───────[ DAYO HELP Called by Program: DAYOMRP Variable: OPT ]───────┐
│ │
│ │
│ │
│ │
│ Type in anything you wish about this portion of the program! │
│ │
│ The length of this file can be many pages... │
│ │
│ Be sure to press Ctrl W to save any changes/additions you make to this │
│ screen. │
│ │
│ │
│ │
│ │
│ │
│ │
├────────────────────────────────────────────────────────────────────────────┤
│ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │
└────────────────────────────────────────────────────────────────────────────┘
■ VIEW DOCUMENTATION ONSCREEN
To view the documentation for the module you are in, it must first exist
in the current directory. Document files are named the same as the module,
and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOMRP.DOC.
Press F1 in the User Defined & Inputted Help Message screen to display the
document (user manual). The special keys in this option are displayed in the
Help Screen (press F1 again) for this option:
╔══════════════════════════════════════════════════════════════════════════╗
║ While viewing the document for DAYOMRP the keyboard is configured ║
║ as followed: ║
║ ║
║ Esc Exit ║
║ F5 Find a string. This search is not case sensitive ║
║ Examples: PAGE: 50 ║
║ INTRODUCTION ║
║ REPORTS ║
║ Home Return to the beginning of the document ║
║ End Go to the bottom of the document ║
║ PgUp Page up ║
║ ║
║ Any other key moves acts like PgDn (page down) ║
║ ║
║ Press any key to continue... ║
╚══════════════════════════════════════════════════════════════════════════╝
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 104
■ DATABASE STRUCTURES
The following is the file structure, in dBase (tm) format for the 4
databases specific to DAYO MRP (BOM.DBF, SO.DBF, SOHIST.DBF, SO_NOTES.DBF)
as of 21 January 1991. Note, you can add additional fields (use the MODIFY
DATABASE option in MISC ROUTINES), but it is not recommended that existing
fields be modified in length and especially type.
■ BOM.DBF STRUCTURE
Field Field name Type Width Dec Start End
----- ---------- --------- ----- --- ----- -----
1 ENDITEM Character 12 1 12
2 DESC Character 30 13 42
3 COST Numeric 10 3 43 52
4 LEVEL1 Character 12 53 64
5 LEVEL2 Character 12 65 76
6 LEVEL3 Character 12 77 88
7 LEVEL4 Character 12 89 100
8 LEVEL5 Character 12 101 112
9 LEVEL6 Character 12 113 124
10 LEVEL7 Character 12 125 136
11 LEVEL8 Character 12 137 148
12 FINIS_QTY Numeric 10 3 149 158
13 WIP_QTY Numeric 10 3 159 168
14 REQ_QTY Numeric 10 3 169 178
15 PER_QTY Numeric 10 3 179 188
16 PTD_QTY Numeric 10 3 189 198
17 YTD_QTY Numeric 10 3 199 208
18 DATE Date 8 209 216
19 LASTDATE Date 8 217 224
20 LASTTIME Character 8 225 232
21 HOURS Numeric 10 3 233 242
22 LABOR Numeric 10 3 243 252
23 LABOR1 Numeric 10 3 253 262
24 LABOR2 Numeric 10 3 263 272
25 OVERRIDE Logical 1 273 273
26 POSITION Character 7 274 280
----- ---------- --------- ----- --- ----- -----
Total 281
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 105
■ SO.DBF STRUCTURE
Field Field name Type Width Dec Start End
----- ---------- --------- ----- --- ----- -----
1 SO Numeric 6 1 6
2 COMMENT Character 30 7 36
3 ENDITEM Character 12 37 48
4 DESC Character 30 49 78
5 QTY Numeric 10 3 79 88
6 COST Numeric 10 3 89 98
7 ASSEMBLED Numeric 10 3 99 108
8 DATE Date 8 109 116
9 DUEDATE Date 8 117 124
10 LASTDATE Date 8 125 132
11 HOURS Numeric 10 3 133 142
12 LABOR Numeric 10 3 143 152
13 LABOR1 Numeric 10 3 153 162
14 LABOR2 Numeric 10 3 163 172
15 PRIORITY Numeric 3 173 175
16 OPEN Logical 1 176 176
17 ALLOCATED Logical 1 177 177
18 PRINTED Logical 1 178 178
19 CUSTOMER Numeric 6 179 184
20 INVOICE Numeric 6 185 190
----- ---------- --------- ----- --- ----- -----
Total 191
■ SOHIST.DBF STRUCTURE
Field Field name Type Width Dec Start End
----- ---------- --------- ----- --- ----- -----
1 SO Numeric 6 1 6
2 COMMENT Character 30 7 36
3 ENDITEM Character 12 37 48
4 DESC Character 30 49 78
5 QTY Numeric 10 3 79 88
6 COST Numeric 10 3 89 98
7 ASSEMBLED Numeric 10 3 99 108
8 DATE Date 8 109 116
9 DUEDATE Date 8 117 124
10 LASTDATE Date 8 125 132
11 HOURS Numeric 10 3 133 142
12 LABOR Numeric 10 3 143 152
13 LABOR1 Numeric 10 3 153 162
14 LABOR2 Numeric 10 3 163 172
15 PRIORITY Numeric 3 173 175
16 OPEN Logical 1 176 176
17 ALLOCATED Logical 1 177 177
18 PRINTED Logical 1 178 178
19 CUSTOMER Numeric 6 179 184
20 INVOICE Numeric 6 185 190
----- ---------- --------- ----- --- ----- -----
Total 191
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 106
■ SO_NOTES.DBF STRUCTURE
Field Field name Type Width Dec Start End
----- ---------- --------- ----- --- ----- -----
1 SO Numeric 6 1 6
2 NOTES Memo 10 7 16
3 COST Numeric 12 3 17 28
4 DATE Date 8 29 36
----- ---------- --------- ----- --- ----- -----
Total 37
■ DATA DICTIONARY
Field Name Type Len Dec Database Comments
----------- ---- ---- --- -------------- ----------------------------------
ALLOCATED L 1 0 SOHIST.DBF Flag to denote whether this shop
SO.DBF order record has been allocated.
Allocating is the process of
updating the REQ_QTY in the
database BOM.DBF with the increase
in item quantity that will be
required to assemble the ENDITEMS
ASSEMBLED N 10 3 SOHIST.DBF Assembled ENDITEMS through the MRP
SO.DBF process. Items finished/built
COMMENT C 30 0 SOHIST.DBF Any user inputted comment or notes
SO.DBF specific to a shop order or an
ENDITEM for a shop order
COST N 10 3 SO.DBF Cost each for an ENDITEM
COST N 12 3 SO_NOTES.DBF Cost each for an ENDITEM or
COST N 10 3 SOHIST.DBF component item
BOM.DBF
CUSTOMER N 6 0 SOHIST.DBF Customer number that the shop order
SO.DBF was created for. Its use is
optional
DATE D 8 0 BOM.DBF Date record was created
SOHIST.DBF
SO.DBF
SO_NOTES.DBF
DESC C 30 0 BOM.DBF Description of the ENDITEM or
SOHIST.DBF component item
SO.DBF
DUEDATE D 8 0 SO.DBF Date the shop order is due to be
SOHIST.DBF completed. Use this field to
schedule shop order/assembly
ENDITEM C 12 0 SO.DBF Number for an assembled item. An
SOHIST.DBF ENDITEM is defined as one made from
BOM.DBF other items in the inventory
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 107
DATA DICTIONARY CONTINUED...
Field Name Type Len Dec Database Comments
----------- ---- ---- --- -------------- ----------------------------------
FINIS_QTY N 10 3 BOM.DBF Finished/Assembled quantity. Needs
to be returned to the inventory so
that it can be later invoiced or
used in further MRP processes
HOURS N 10 3 SOHIST.DBF Total hours per item required to
SO.DBF assemble it
BOM.DBF
INVOICE N 6 0 SOHIST.DBF Invoice number that the shop order
SO.DBF was created for. Its use is
optional
LABOR N 10 3 BOM.DBF Total labor cost per item
SO.DBF
SOHIST.DBF
LABOR1 N 10 3 SOHIST.DBF Alternate labor cost per item
SO.DBF
BOM.DBF
LABOR2 N 10 3 SOHIST.DBF Alternate labor cost per item
BOM.DBF
SO.DBF
LASTDATE D 8 0 SOHIST.DBF Date of last access
BOM.DBF
SO.DBF
LASTTIME C 8 0 BOM.DBF Time of last access
LEVEL1 C 12 0 BOM.DBF BOM level 1 item number
LEVEL2 C 12 0 BOM.DBF BOM level 2 item number
LEVEL3 C 12 0 BOM.DBF BOM level 3 item number
LEVEL4 C 12 0 BOM.DBF BOM level 4 item number
LEVEL5 C 12 0 BOM.DBF BOM level 5 item number
LEVEL6 C 12 0 BOM.DBF BOM level 6 item number
LEVEL7 C 12 0 BOM.DBF BOM level 7 item number
LEVEL8 C 12 0 BOM.DBF BOM level 8 item number
NOTES M 10 0 SO_NOTES.DBF Shop order expanded notes or
comments. Use this routine to save
any amount of information about a
shop order. Note, the first 21
lines of the notes is printed onto
the shop orders
OPEN L 1 0 SOHIST.DBF Flag to denote whether shop order
SO.DBF is open (.T., not yet assembled) or
closed (.F.)
OVERRIDE L 1 0 BOM.DBF Not used...
PER_QTY N 10 3 BOM.DBF Quantity required to make 1 unit
for use in the Bill of Materials
for an ENDITEM
POSITION C 7 0 BOM.DBF The position of a component item in
a Bill of Materials
PRINTED L 1 0 SO.DBF Flag to denote whether a shop order
SOHIST.DBF has been printed
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 108
DATA DICTIONARY CONTINUED...
Field Name Type Len Dec Database Comments
----------- ---- ---- --- -------------- ----------------------------------
PRIORITY N 3 0 SO.DBF Priority flag to denote a priority
SOHIST.DBF of a shop order. User defined...
PTD_QTY N 10 3 BOM.DBF Period to date quantity of items
used in MRP
QTY N 10 3 SO.DBF Quantity of items to be assembled
SOHIST.DBF or built per shop order ENDITEM
REQ_QTY N 10 3 BOM.DBF Required quantity to be taken from
the inventory in order that the
required number of ENDITEMS be
built
SO N 6 0 SO_NOTES.DBF Shop order number
SOHIST.DBF
SO.DBF
WIP_QTY N 10 3 BOM.DBF Work In Process quantity. This is
a 'physical' record of the numbers
of items moved from the inventory
into work in process. This quantity
is accountable, and will be used to
create/assemble/build the ENDITEM
YTD_QTY N 10 3 BOM.DBF Year to date quantity of items used
in MRP
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 109
■ DAYO MRP MAINTENANCE & QUIRKS
- If you are on a multiuser network, you must 'flag' (change file attributes)
of all files to make them sharable, readable and writable. Note that the
command/program 'flag' may be called by a different name on your network.
ie:
E:\>FLAG *.NTX SRW
or just to be safe, go ahead and flag all files in the DAYO directory:
E:\>FLAG *.* SRW
- On many networks, you must load the program SHARE or its replacement at boot
up time on the server in order to make files sharable.
- Backups of your data and configuration files should take place daily! You
have no doubt heard many 'scare' stories about losing data. They are all
true! The key files that need to be backed up all have the extension of
.DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files
are notes/memos. The .CFG file(s) contain your configuration information
(as seen in the Configuration module).
- If you are on a network, it is NOT recommended that you use dBase III+ with
the databases. It may write an end of file marker not always recognized by
DAYO. Appending additional records to the database after this point often
leads/creates a 'bad record' in the database. If you do use it (as we do),
use it with caution and check frequently to insure no damage has been done!
- If you must use dBase (tm) with DAYO MRP, and you are on a PC based
network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases.
This will allow the opened databases to be shared, and more importantly,
prevent a user (or all users!) from 'crashing'!
- If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then
do not use it... Hope to fix this 'feature' with the next upgrade...
- To clear the Period to Date (PTD_QTY) and/or Year to Date (YTD_QTY) fields
in the BOM database (BOM.DBF), use a routine in the Smart Reports.
DAYO MRP VERSION 4.0, TJS LAB Orlando, Florida Page: 110
■ TJS 'Computer' LAB
TJS LAB produces customized, multiuser software for the PC based network
(ie: Novell and others). Our specialties include Inventory Control, PC
Communications/EDI, Management, Reports (standard and graphic), Data
Conversions, and Accounting (ie: A/R, A/P, G/L).
A unique feature of TJS LAB is that our software is by default, multiuser.
'Standalone' applications are the exception! All our applications are
written in Clipper, Basic, or C (preferably Basic or Clipper). We will
license all our application source codes. We produce applications that work,
are easy to use, and are very reasonably priced!
Custom/contract programming is available. We make program enhancements and
changes very quickly; usually within 24 hours!
Want a change?
Want an enhancement!
Want a completely new product/application?
Want to make your idea a reality?
Call us for a quote or just for more information!
Write us at:
TJS LAB
PO Box 585366
Orlando, Florida 32858
Or call us, 09:00am to 5:00pm Mon-Fri (407) 291-3960
Voice Mail (any time): (407) 292-4708
┌──────────────────────────────────────────────────────────────────────┐
│ Note that TJS LAB will not accept/take any support calls for │
│ UNregistered products! │
└──────────────────────────────────────────────────────────────────────┘